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")
What's the circular dependency?
I entered this formula
= IF( [Delta Turnover Detailed] = 0, "Match", "No Match")
Maybe because i'm referencing a measure which is also calculated on this table.