Forum Discussion

Tyler_T's avatar
Tyler_T
New Member
3 years ago

IF function and Measures

Hello,

 

I am struggling to get something that I think should be simple working. I would like to have a calculated column added to my main data table that compares the value of one column line by line against a measure that is a text value and returns a 1 if they are equal and 0 if they are not.

 

The DAX statement I would like to use is Dedication Match = IF([Dedication 1] = [Selected Group], 1,0) but the 1s and 0s it returns doesn't match up

 

[Dedication 1] is a text value from the data source and [selected group] is a SELECTEDVALUE measure that returns the text value of the selected item of a dropdown in a single column group table.

 

If I replace the measure with just the text value of the measure in parentheses it returns the right 1s and 0s.

 

Am I doing something wrong or with calculated columns can you only use the IF statement to comapre the value of a cell against a simple text or numerical value?

Need Help

1 Reply

  • Manoj_Nair's avatar
    Manoj_Nair
    Solution Supplier
    3 years ago

    Tyler_T- Check this out and let me know if this works or not?

    Dedication Match Measure =
VAR CurrentDedication = MAX('Table'[Dedication 1])
VAR CurrentGroup = [Selected Group]
RETURN
IF(CurrentDedication = CurrentGroup, 1, 0)