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

[@powerbizone]

You can download the pbix file for your self practice sessions from : drive.google.com/file/d/1AeNZ7RQaVb2pGZpGt0WeHdI_V9nQK4DE/view?usp=sharing Do not forget to Like ,Subscribe and comment which keeps me motivated !

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

Thank you so much! you are a real lifesaver!

[@powerbizone]

thnx :)

[@asaravana3966]

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

[@powerbizone]

Glad it helped you dear:) ..Keep practising & plz dont forget to subscribe !

[@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?

[@amitshukla189]

The way you explain logic is outstanding.

[@powerbizone]

thanks

[@richardsaldana4880]

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!

[@faisalag9611]

Awesome. Thanks for sharing.

[@powerbizone]

My pleasure :)If you like the video don't forget to subscribe to our channel.

[@akankshatripathi8048]

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

[@powerbizone]

Thanks for the comment Akanksha ..Why would the sales for multiple months be same :).Just a thought .This should work for any numbers actually .Do let us know if its not .Also do refer to the below arrticle community.fabric.microsoft.com/t5/Desktop/Last-12-Months-of-Running-Total-Measure/td-p/2034692

[@siewleesiewlee3638]

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

[@powerbizone]

Thank you for your comment.Sales Amount is a column while rank and RT for sales are measures .The total would appear perectly for any inbuilt column while logic differs when measures are in place .You can simply turn off the total

[@mohamedmubeen2913]

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?

[@powerbizone]

Thank you for letting us know. We will reupload and let you know once done.

[@powerbizone]

Bro..try now drive.google.com/file/d/1AeNZ7RQaVb2pGZpGt0WeHdI_V9nQK4DE/view?usp=share_link

[@mohamedmubeen2913]

@@powerbizone Thank you so much for your responses bro, I fix the issue

[@powerbizone]

@@mohamedmubeen2913 Welcome bro and if you like the content ,do subscribe !

[@mohamedmubeen2913]

@@powerbizone Sure👍

[@sharonrubavathy5812]

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 drive.google.com/file/d/16B_PL6pYo4HmsyCILRmXJL0WIXt_NYsa/view?usp=share_link

[@powerbizone]

Just at initial thoughts ,you are calling one measure from inside another .Also once you use ALLSELECTED inside RANKX its bound to take time since it will calculate from beginning till that row "for each row".Bro,Did you try troubleshooting via performance analyzer ?

[@sharonrubavathy5812]

@@powerbizone no I didn't know to use performance analyzer. Can you please provide me with a optimized code. Please help me in this issue. Been struck in this real time project for past 2 weeks.

[@powerbizone]

@@sharonrubavathy5812 Bro its late night in my Country ..Will try your code tomorrow and let you know . In mean while try community.powerbi.com/t5/Desktop/Running-Total-on-a-non-date-column/m-p/44470

[@sharonrubavathy5812]

@@powerbizone yeah sure no issues. Please do try tomorrow and help me. Grateful to you

[@sharonrubavathy5812]

@@powerbizone hi. Did you try on the measure brother. I couldn't resolve it . If u have any suggestions, please let me know