Forum Discussion
DAX statement error
I am trying to write a DAX statement something like :
Hi, Anonymous
Your filter expression is incorrect. As mentioned in the error message,each true/false expression used as a table filter expression must refer to exactly one column.
You can add filter like below：
Measure = CALCULATE(SUM('table name'[column name]),('table name'[column name]) in { "C", "O"})Best Regards,
Community Support Team _ Eason
4 Replies
Anonymous
Please refer to this post >>Solved: True/False expression doesn't specify a column - Microsoft Power BI Community
When you get this problem, you could check if your CALCULATE() formula has a direct TRUE/FALSE filter. You need use a FILTER() formula to surround the TRUE/FALSE condition.
Regards,
Ritesh
Anonymous
CALCULATE(SUM(table name[column name]),(table name[column name]) = "C", "C","O")
Can you explain what is the condition here?
Hi, Anonymous
Your filter expression is incorrect. As mentioned in the error message,each true/false expression used as a table filter expression must refer to exactly one column.
You can add filter like below：
Measure = CALCULATE(SUM('table name'[column name]),('table name'[column name]) in { "C", "O"})Best Regards,
Community Support Team _ EasonHi,
Try this measure
CALCULATE(SUM(table name[column name]),table name[column name]) = "C"||table name[column name]) = "O")
Hope this helps.
