Forum Discussion
Tyler_T
3 years agoNew Member
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 l...
Manoj_Nair
3 years agoSolution Supplier
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)