Forum Discussion
Solved
IF statement in measure
I’m trying to compare the Turnover per ID (OID) from 2 systems. If they don’t match the difference is calculated with a measure as in the picture below. I would like to add another measure that does ...
MatchFlag = IF( [Delta Turnover Detailed] = 0, "Match", "No Match")
MatchFlag = IF( [Delta Turnover Detailed] = 0, "Match", "No Match")
Awesome Cmcmahan , that does the trick! Just one more question, is it possible to use this also as a filter?
So I can filter the table on whether it's a match or not?
You can filter on the measure in the visual level filter if the measure is part of the displayed data.
If not, you need to set it up as a calculated column, and then you can slice/filter on that.
Tha's unfortunately not possible, since it'll say I have a circular dependency...
