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")
Cmcmahan
Resident Rockstar
Resident RockstarMatchFlag = 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
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.
- MauriceMecowe
Tha's unfortunately not possible, since it'll say I have a circular dependency...
- Cmcmahan
What's the circular dependency?