How to cumulate %-of Grand Total Value colum (Cumulative total)

[Anonymous]

Hello everyone,

I would like to visualize the following excel logic in PowerBI Desktop, to make an ABC classification based on the cumulative values ( = %-Summiert).

Excel ViewPowerBI View

I managed to calculate the % of the grand total as a measure (dynamically, based on chosen filter selections). Yet, I haven't figured out a way to likewise cumulate the individual %-values dynamically.

The row context is defined by material numbers:

Does anyone know how to calculate the (%-summed) column in Power BI Desktop. Any input is highly appreciated!

Cheers Dominik

[v-juanli-msft]

Hi @Anonymous 

Is [%_wet], [%_summiert] columns or measures?

You could refer to:

ABC Classification

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

In Quick measure, try running total.

[Anonymous]

And what Value am I supposed to select in the field box?

Screenshot