Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cumulative Totals using Multiple filter columns, Taking longer time to display the result.

Hello,  I am trying to calculate cumulative totals based on 3 different filters, (Item, Unit, Company), I am facing a challange where in when i am trying to display the result in Table chart, It is ...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

didnt you try a measure like?

 Cumulative Total = CALCULATE(SUM(Table1[Quantity]),ALLEXCEPT(Table1,Table1[Item],Table1[Unit],Table1[Company]), Table1[Quantity]<=MAX(Table1[Quantity])))

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes, I have tried using this DAX as well, but it doesnt give me the required results.