Forum Discussion

newbie9292's avatar
newbie9292
Helper II
4 years ago

Cummulative total for drill down view

I am new to power bi and trying to get the cummulative total for my data.

 

With my current DAX query I am able to get the cummulative total for the topmost level but the same is not working when I drill down to the next level. Please help. 

This is my DAX query : 
Umsatz_KUM =
CALCULATE (
SUM ( Drill_down_data[Umsatz_All] ),
FILTER (
ALLSELECTED(Drill_down_data),
Drill_down_data[Monat]<=MAX(Drill_down_data[Monat])
)
)
Need Help

1 Reply

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi newbie9292 

     

    If you simply your measure and use a Date table, it will certainly assist. Please try the following:

     

    Measure = TOTALYTD ( SUM ( Drill_down_data[Umsatz_All] ) , Dates[Date] )

     

    Otherwise, if you don't have a Date table, you can use:

     

    Measure = TOTALYTD ( SUM ( Drill_down_data[Umsatz_All] ) , Drill_down_data[Date] )

     

    Hope this helps 🙂

     

    Theo