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.

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , instead of values use max or selectedvalue on Table[View]

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandakI tried using both max and selectedvalues instead of values, but unfortunately got the same error message. Any other ideas??

      • v-eachen-msft's avatar
        v-eachen-msft
        Community Support
        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.