Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[saurabh Singh]

Hello,  
I’m having a table of material code (type Text) & its value (type decimal). I need to create a table of all materials having Value (in decreasing order) and its cumulative %. 
Later i want this slicer of cumulative % to filter the data. For example – List of materials having top 68% of stock
 

——————————
Thanks and Regards:-
Saurabh Singh

——————————

[Vincent Lacomme]

Hi Saurabh,

Creating the cumulative % can be accomplished using a measure.
However, you can’t use a measure as a filter for a matrix.

So I created a second table that summarize your data (with distinct material ID) and with a cumulative % column. Then I use this second table as a filter.

Enclosed is an example PBIX.

——————————
Vincent L.
Chartered accountant – Expert-comptable
——————————
——————————————-

[saurabh Singh]

Dear Vincent L.,

Very thanks for your solution. 

The provided solution guided me towards a right path but their small issue with cumulative % calculation.
Cumulative % should be increasing till it’s 100% in last row of table (if no filter is applied) like running total.

Request you to please have a look on cumulative % calculation.

Thanks and Regards:-
Saurabh singh

?

——————————
saurabh Singh
Manager
——————————
——————————————-