The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.

Subbulakshmi S 0 Reputation points
2024-01-21T08:29:16.8033333+00:00

Team, I have trying to create table with two fields. One of the field I am pulling dax function which I have created. Getting (The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column.) I want my filed to present data based on filter value which is selected by user.

Forecast Table2 = 
{("Global Sourcing",CALCULATE([GlobalFinance_FC],SELECTEDVALUE('Forecast Version'[Forecast Week Version])))}
Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 25,687 Reputation points Microsoft Employee
    2024-01-22T21:37:10.53+00:00

    Hi, @Subbulakshmi S Welcome to Microsoft Q&A thanks for posting your question.

    Based on the information you have provided, it seems like the issue might be with the CALCULATE function in your DAX expression. The SELECTEDVALUE function is returning a single value, but the CALCULATE function is expecting a column reference.

    Can try modifying your DAX expression to use a FILTER function instead of a CALCULATE function. Forecast Table2 = FILTER('Global Sourcing', [Forecast Week Version] = SELECTEDVALUE('Forecast Version'[Forecast Week Version]))

    Regards

    Geetha

    0 comments No comments