Running Total in Power BI for non date Values | How to calculate running total in Power BI using DAX

#dax #powerbi_training #powerbidax
We learn how to calculate running total in Power BI for non date values using DAX.In the earlier video we found out the process to create a running total for date values.So we have two options for the running total :
1.Option 1: Using sort on country column.Here we apply the below logic in DAX and create a measure as shown :
RT for Country =
CALCULATE([Sum_Sales],
FILTER(ALL(DimGeography[EnglishCountryRegionName]),
DimGeography[EnglishCountryRegionName]less than =max(DimGeography[EnglishCountryRegionName])
))

RT for Sales_Amount =
var current_Rank=RANKX(ALL(DimGeography[EnglishCountryRegionName]),
[Sum_Sales],,DESC,Dense)

var Result=CALCULATE([Sum_Sales],
FILTER(ALL(DimGeography[EnglishCountryRegionName]),
RANKX(ALL(DimGeography[EnglishCountryRegionName]),
[Sum_Sales],,DESC,Dense) less than=current_Rank)
)
return Result

This is a really useful feature and one that you should definitely learn how to use!

Check out other Power BI Tutorials Videos :
17.How to calculate Running total for date values in Power BI

Learn Power BI through our vlog and Free Videos:

You can download the pbix file for your self practice sessions from :
Do not forget to Like ,Subscribe and comment which keeps me motivated !

[powerbizone]

You can download the pbix file for your self practice sessions from :
Do not forget to Like, Subscribe and comment which keeps me motivated !

[ЕкатеринаТиньгаева-йч]

Thank you so much! you are a real lifesaver!

[asaravana]

Thank you sir it helps me a lot I struggle for 1week

[richardsaldana]

I have a similar goal to the tutorial you provided; however, in the case if you were to filter out a country like united states, I would like the cumulative total to start at the next highest country. Could you provide insight to how that can be done? Many thanks!

[siewleesiewlee]

why the grand total value is not equal to total 2.93m

[akankshatripathi]

How to do running total if the measure value (Sales in your case) is repeating. Dense Rank will give repeated values.

[mohamedmubeen]

Failed to save modifications to the server. Error returned: 'The following system error occurred: Class not registered
'. I got this error while loading data, what can I do?

[sharonrubavathy]

I am trying to do running total on non date column. I am trying to show it in a table visual. I have 18k rows.
Following the dax, its working for me but takes some 20 minutes for loading the table visual.
Can you help me in optimizing the measure or any other way to achieve running total faster. Not sure, why just for 18k rows of data, its taking too long to load the running sum measure.

I am attaching the error and sample file below. Please help me out. If u drag the running sum measure into table visual, its taking too long to load

[amritwadhwa]

Very good video. Thanks for explaining this so clearly. Is there a way to get rid of '1' that appears on the column subtotal?

[amitshukla]

The way you explain logic is outstanding.