Forum Discussion

RichardMo's avatar
RichardMo
Frequent Visitor
3 years ago

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...
Cumulative Sum
GuillaumePower's avatar
GuillaumePower
Icon for Resolver I rankResolver I
3 years ago

It is not necessary to add  this filter "Table1[region]=SELECTEDVALUE(Table[region])" in the DAX command. You can use a slicer on the region which could select one or more region. You will get the right cumul.

  • RichardMo's avatar
    RichardMo
    Frequent Visitor
    3 years ago

    When I had a slicer on region, or any other column, it didn't filter the cumulative chart. 

    • GuillaumePower's avatar
      GuillaumePower
      Icon for Resolver I rankResolver I
      3 years ago

      You 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.