Cummulative total for drill down view

[newbie9292]

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])

)

)

[TheoC]

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