Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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 ViewExcel ViewPowerBI 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:

 

Row Context.png

 

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

 

Cheers Dominik

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

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
Super User
Super User

In Quick measure, try running total.

Anonymous
Not applicable

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

 

ScreenshotScreenshot

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.