Cumulative of Percentage in DAX

[Anonymous]

Need to have a DAX formula to create cumulative of percentage, I need the value like highlighted, its doing cumulative of column C as percentage. Please help

[Syndicate_Admin]

Hello, I have the same need but the percentage of the total is a calculated measure

% of total = WHERE BEFORE=

SUM(T_VENT_E[USD])

WHERE TOTALPRIMA=

SUMX(

ALLSELECTED(T_VENT_E),

T_VENT_E[USD]

)

RETURN

DIVIDE(BEFORE,TOTALPRIMA)

Now I need to accumulate the percentage of result with another measure, I do not know if it is possible, it helps.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

The main idea is to first create column B, get the value of the previous row, and then use divide to calculate the result of divide (11.29-11.23, 11.23,0). Then find column C according to the calculation in column B. You can refer to the links to similar questions below, the ideas are basically the same.

link:Solved: get value from Previous row - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information. Let me know the result immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

thank you for the suggestion, i am not getting any error but the output I need in column D is not coming.

Please take some example and show me how to get this..

[amitchandak]

@Anonymous , if C is a column

calculate(sum(Table[C]), filter(allselected(Table),Table[datetime_date] <=max(Table[datetime_date])))

or C is measure

calculate(sumX(values(Table[datetime_date]) ,[C]), filter(allselected(Table),Table[datetime_date] <=max(Table[datetime_date])))

[Syndicate_Admin]

Thank you very much for the information! I was looking at how to make the cumulative % from a measure.

I work perfectly😁

[Anonymous]

Thanks @amitchandak for your response, I forgot to mentioned that Column C is also a calculated value from column B doing e.g divide(11.29-11.23, 11.23,0) = 0.47% ans so on (this is not actual but this is how its has been derived.)