Forum Discussion
MauriceMecowe
Resolver II
Resolver IIIF 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")
MauriceMecoweResolver II
Resolver IIAwesome 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?
Cmcmahan
Resident Rockstar
Resident RockstarYou 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.
- MauriceMecowe
Tha's unfortunately not possible, since it'll say I have a circular dependency...
- Cmcmahan
What's the circular dependency?
- MauriceMecowe
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.