The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
I have a card which is producing a value based on the latest month in the data (currently September).
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
Solved! Go to Solution.
Try
Current_month =
IF (
MAX ( Outflow[Financial Month] )
= CALCULATE ( MAX ( Outflow[Financial Month] ), REMOVEFILTERS () ),
CALCULATE ( Measure[Total_FTE], LASTDATE ( Outflow[Financial Month] ) ),
0
)
Try
Current_month =
IF (
MAX ( Outflow[Financial Month] )
= CALCULATE ( MAX ( Outflow[Financial Month] ), REMOVEFILTERS () ),
CALCULATE ( Measure[Total_FTE], LASTDATE ( Outflow[Financial Month] ) ),
0
)
Seems to work great. Thank you