Forum Discussion

cwermager's avatar
cwermager
Frequent Visitor
5 years ago

Running Total Based on Rank with Filters

Hi all.   I've scoured the forums for days to no avail. I'm no DAX expert, but have tried seemingly infinte variations of the proposed solutions. I'm trying to calculate a running total based on a ...
Need Help
FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi cwermager 

I think you can do it like this:

 

 

Division = DIVIDE(MIN('Table'[Benefit]),MIN('Table'[Cost]))

Rank = RANKX(ALLEXCEPT('Table','Table'[Area]),[Division],,DESC,Skip)

 

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

cwermager's avatar
cwermager
Frequent Visitor
5 years ago

Thanks FrankAT. The rank is actually the one part that seems to be working. I am struggling to then take that rank to get a running cost total.