Forum Discussion

newbie9292's avatar
newbie9292
Icon for Helper II rankHelper 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 ...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity 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