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 value in Column 2 it will result in a Yes answer so that I can include it in a Slicer visual.

 

So far the measure I have is:

 

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

 

but that comes up with errors even with every type of punctuation variation. 

 

Any help would be appreciated.

Thanks in advance

 

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.
      

3 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.