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/6...
When i use country column in the measure i am getting like below cummulative is not coming in correct way. Please see below
Cumulate percentage measure: =
VAR _percentage = [Percentage %]
VAR _cumulate =
SUMX (
FILTER (
ALL ( 'DB 15092022_1'[country]),
[Percentage %] >= _percentage
),
[Percentage %]
)
RETURN
_cumulate
Jihwan_Kim
Super User
Super UserHi,
May I ask, do you want to cumulate by country code alphabetical order? Or, by QTY descending order?
I think the measure is showing cumulate percentage by QTY descending order.