Ignore filter context for part of measure

[Anonymous]

Hi

I have a card which is producing a value based on the latest month in the data (currently September).

Current_month =

CALCULATE (Measure[Total_FTE], lastdate(Outflow[Financial Month]))

When the card is filtered using a slicer, it shows the latest month available for the filtered value, in this case August.

However, i would like the card to show zero to represent there is no value for the latest month available in the whole dataset

Any help greatly appreciated

[johnt75 · Accepted solution]

Try

Current_month =
IF (
    MAX ( Outflow[Financial Month] )
        = CALCULATE ( MAX ( Outflow[Financial Month] ), REMOVEFILTERS () ),
    CALCULATE ( Measure[Total_FTE], LASTDATE ( Outflow[Financial Month] ) ),
    0
)

[Anonymous]

Seems to work great. Thank you