cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Running Totals on a row count

I am trying to create a calculated measure using DAX that will do a running total on a row count for a field that contains descriptions. Each descripton would be a row count. For instance we have a field called color and there are 5 colors.  I want a running total on how many rows are what colors.  Also I need to keep all the current filters in place so if the filters change, my running total will reflect that.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Running Totals on a row count

Try Quick measure. There is an option for running a total. Right-click on a table or field you get popup menu. There choose new quick measure





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Running Totals on a row count

Try Quick measure. There is an option for running a total. Right-click on a table or field you get popup menu. There choose new quick measure





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


View solution in original post

Community Support
Community Support

Re: Running Totals on a row count

hi @Anonymous 

You could refer to this document:

https://www.daxpatterns.com/cumulative-total/

For your case, you may need to use ALLSELECTED Function instead of ALL Function in the formula.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Running Totals on a row count

No it doesn't really help.  I am trying to do a cumulative on a description field where I row count.  For example:  I have 500 employees. Of those 500 employees, 100 have been Terminated.  I am trying to count the rows where there is a reason code and I want it to look like this...  But I don't want my line to follow but be a cumulative line upward.  PowerBI Issue.PNG

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors