Forum Discussion
Total measurement Display
Good morning, I have a problem displaying my grouped chart. I have a measurement (cumulative) that I am displaying and I only want to display it up to today's date and once moved to the other m...
Measurement I use is :
TotalCumule =
CALCULATE(
COUNTA('BD_SAV'[DateValExpe]),
FILTER(
CALCULATETABLE(
SUMMARIZE(
'BD_SAV',
'BD_SAV'[DateValExpe].[NoMois],
'BD_SAV'[DateValExpe].[Mois]
),
ALLSELECTED('BD_SAV')
),
ISONORAFTER(
'BD_SAV'[DateValExpe].[NoMois], MAX('BD_SAV'[DateValExpe].[NoMois]), DESC,
'BD_SAV'[DateValExpe].[Mois], MAX('BD_SAV'[DateValExpe].[Mois]), DESC
)
)
)