Forum Discussion
Running Total
Hello All, Please help me with this. Revenue is a Default meausre from SQL server source. I calulated Revenue Contribution(Measure) as DIVIDE(SUM(Query1[Revenue]),[Total Revenue],0) then after so...
I wrote a blog post today about how to create a Pareto Cumulative Running Total
http://exceleratorbi.com.au/cumulative-running-total-based-on-highest-value/
=calculate([contribution],filter (all(table),table[item] <=max(table[item])))
Negative MattAllington..!!
how can we use '<= max(item)' condition, when Items are sorted in desccending order of contribution...??
what if I dont have Item Number and want to use Item Name from dimension, this max() function shouldn't work with strings as far as i know.