Forum Discussion

v-rouge's avatar
v-rouge
Regular Visitor
5 years ago
Solved

IF Measure resulting in Yes/No Calculated Column

Hello,   I am trying to create a measure with an IF filter resulting in a Yes/No column but keep coming up to problems.    I have two columns where if the value in Column 1 is greater than the va...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    v-rouge 
    To create a if measure, you need to add a aggregation function for the columns (sum, max or min).

    Measure = IF(SUM('Table'[Column1])>SUM('Table'[Column2]),"YES","NO")

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
      

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Try this

Measure 1 = IF(SELECTEDVALUE('Table'[Column1])>SELECTEDVALUE('Table'[Column 2]),"Yes","No")

 

v-rouge's avatar
v-rouge
Regular Visitor
5 years ago

Many thanks for responding @VikramBasriyar

The measure is correct (in that there are no errors) but all results still come up as No even though I know that some should be Yes.