Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cummulative Sum responding to Slicer

Hi all,   I am trying to create a cummulative sum which goes with the slicer, meaning if I select the numbers: 3, it will retrieve the data all to the number 3.   Cumm = calculate(all(MS_CY[CY.N...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may create measure like DAX below.

     

    Measure1= CALCULATE(SUM(MS_CY[CY.NS3rd]),FILTER(ALLSELECTED(MS_CY), MS_CY[UnitName]=MAX(MS_CY[UnitName])&&MS_CY[Periodnumber]<=MAX(MS_CY[Periodnumber])&&MS_CY[TimeBasis]="Periodic"))

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You may create measure like DAX below.

 

Measure1= CALCULATE(SUM(MS_CY[CY.NS3rd]),FILTER(ALLSELECTED(MS_CY), MS_CY[UnitName]=MAX(MS_CY[UnitName])&&MS_CY[Periodnumber]<=MAX(MS_CY[Periodnumber])&&MS_CY[TimeBasis]="Periodic"))

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.