Forum Discussion
Cummulative sum in a column
Hi,
1) I have Grand Total column as below, from that i need to get % column value listed below.
Grand Total 656,306
to get 30% i need to do 197,829/656,306 = 30%
to get 13% i need to do 84,635/656,306 = 13% ....so on
2)How can i get the cummulative sum from the %column?
1st row values remains same as 30%.
2nd row column value - 30%+13% = 43%
3rd row column value - 30+11+13 = 54% etc...
Please advise
Grand Total656,306
| % | **bleep** | |
| 197,829 | 30% | 30% |
| 84,635 | 13% | 43% |
| 69,128 | 11% | 54% |
| 51,932 | 8% | 61% |
| 45,210 | 7% | 68% |
| 41,335 | 6% | 75% |
| 35,815 | 5% | 80% |
| 26,962 | 4% | 84% |
| 13,781 | 2% | 86% |
| 13,417 | 2% | 88% |
| 9,752 | 1% | 90% |
| 9,750 | 1% | 91% |
| 9,456 | 1% | 93% |
| 9,378 | 1% | 94% |
| 9,111 | 1% | 96% |
| 8,394 | 1% | 97% |
| 5,577 | 1% | 98% |
| 5,191 | 1% | 99% |
| 4,373 | 1% | 99% |
| 2,976 | 0% | 100% |
| 1,824 | 0% | 100% |
| 480 | 0% | 100% |
| 656,306 |
9 Replies
- Jihwan_Kim
Super User
Hi,
Please check the below picture and the attached pbix file.
Percentage measure: = VAR _qty = SUM ( Data[Quantity] ) VAR _allqty = CALCULATE ( SUM ( Data[Quantity] ), REMOVEFILTERS () ) RETURN DIVIDE ( _qty, _allqty )Cumulate percentage measure: = VAR _qty = SUM ( Data[Quantity] ) VAR _cumulate = SUMX ( FILTER ( ALL ( Data[Quantity] ), Data[Quantity] >= _qty ), [Percentage measure:] ) RETURN _cumulate- Jihwan_Kim
Hi,
Could you please share your sample pbix file's link here? And then I can try to look into it to come up with a more accurate solution.
Thanks.
