I’m using non-numeric fields to get a Running Total of Total Sales data.
The problem is my measure below doesn’t recognize the increments from identical values. It simply repeats them instead of adding them up to the previous total -
Company A*, Company B (both $500,000) are not added up
Can you plesae tell me how to get around this issue??
Thank you so much for any solution.
Best regards, Rafal
BTW, I’ve also tried a different measure using RANKX, but to no avail.
It’s adding both values in one go. You’ll need to break the ties to seperate them out. To achieve this you can introduce another column to the ranking logic. See the article and or video below.
Hello
Thank you for your solutions in a lightining time
This tie breaker is exactly what I was missing! And the problem has been solved. After creating Brand Ranking with Ties Broken measure, I threw Alphabetical Ranking measure in to the mix and finally used RANKX to calculate Running Total - check the detailed print screen and new .pbix file.
The topic can be closed now. And I’ll have yet another thing to think about - if it’s possible to get the proper Running Total with SUMX and a virtual table (SUMMERIZE) which was my initial idea.
