Forum Discussion
Cumulative chart with filter
Beginner level. I have a table with columns including ‘week_start_date’, ‘region’, and 'appointment_count'. I have a measure for a chart showing cumulative appointment_count over time, which work...
When I had a slicer on region, or any other column, it didn't filter the cumulative chart.
GuillaumePower
Resolver I
Resolver IYou should use this Dax Command whith AllExcept for the region :
Cumulative Mesure = calculate(sum(Feuil1[index]),filter(ALLEXCEPT(Feuil1,Feuil1[Region]),Feuil1[index]<=MAX(Feuil1[Index])))
Have you all your Data in the same Table ? That should run well like that.