Forum Discussion
Filter Context not propagating with IF function used in a measure
Anonymous
You can modify your measure
Volume Check = IF ( [Volume] > 10000, "Flag", IF ( [Volume] > 0, "Ok" ) )
or
Volume Check = IF ( NOT ISBLANK ( [Volume] ), IF ( [Volume] > 10000, "Flag", "Ok" ) )
Community ChampionAnonymous
I don't think IF has anything to do with that. Place the measure [Volume] in the table and see what values you get.
again by placing a filter from another dim table you have changed the filter context. The values of the comparison measure will be diffrent (less)
Hi tamerj1
Everything works as expected. I created a table to test by placing Project Number, Business Unit, and Launch Year (all fields from my dimensions) along with my Volume measure and filter context works as it should.
For reference, below is the calculation for Volume. One thing to note is that I like to branch my measures, so the "MASTER TOTAL" measure is simply a SUM of the values column in my fact table.
Volume =
CALCULATE(
[MASTER TOTAL],
'Activity Metrics Detail'[Line Item] = "Volume"
)
- tamerj1
Anonymous
You can modify your measure
Volume Check = IF ( [Volume] > 10000, "Flag", IF ( [Volume] > 0, "Ok" ) )
or
Volume Check = IF ( NOT ISBLANK ( [Volume] ), IF ( [Volume] > 10000, "Flag", "Ok" ) )