Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

True/False expression doesn't specify a column

Can someone help me fix what's causing the error is this formula?  
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

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.