Running total and sum of Running total

[Anonymous]

Hi Guys

I need DAX function for below statement.

we can easy to do running total, but after running total, how do we do sum of all running total.(Refer I column)

need dax for I coumn.

[Anonymous]

Please learn a bit about how to create good models in PBI and calculations:

https://www.youtube.com/watch?v=_quTwyvDfG0

https://www.youtube.com/watch?v=78d6mwR8GtA&t=1247s

Working with PBI and DAX is VERY different from Excel.

Best
D

[Greg_Deckler]

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[Anonymous]

Thankyou dear friend, 

i am new to power BI and this is look so diffcult

i have created some DAX kindly review it

Running Total for Basic Salary = IF(ISFILTERED(Ddatetable[Month]),CALCULATE([Total Basic Salary],FILTER(ALL(Ddatetable),Ddatetable[Date] <= max(Ddatetable[Date]))),SUMX(SUMMARIZE(Ddatetable,Ddatetable[Month],"Sum",CALCULATE([Total Basic Salary],FILTER(ALL(Ddatetable),Ddatetable[Date] <= max(Ddatetable[Date])))),[Sum]))