Calculate Cumulative% in decreasing Order and filter it by Cumulative% Slicer

  • Calculate Cumulative% in decreasing Order and filter it by Cumulative% Slicer

    Posted by DSC Communities on April 17, 2020 at 3:39 pm
    • saurabh Singh

      Member

      April 17, 2020 at 3:39 PM

      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

      Member

      April 19, 2020 at 5:33 AM

      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

      Member

      April 19, 2020 at 8:14 AM

      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
      ——————————
      ——————————————-

    DSC Communities replied 5 years, 11 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Calculate Cumulative% in decreasing Order and filter it by Cumulative% Slicer’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!