Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago
Solved

Pareto not working

Hi all I have the following table:       The pareto should sum the column % of dedicated time to look cumulative like this:     The measure used is:   Pareto = VAR demand = [...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi o59393 ,

     

    You should create index column in power query. Then try formula like below:

    pareto =
VAR cur_ = 'Table'[Name]
VAR cur_index = 'Table'[Index]
RETURN
    SUMX (
        FILTER ( ALL ( 'Table' ), 'Table'[Name] = cur_ && 'Table'[Index] <= cur_index ),
        [TotalPercentage]
    )

    Best Regards,
    Adamk Kong

     

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

     

AhmadBakr's avatar
AhmadBakr
Helper IV
2 years ago

To get the Pareto working correctly:
either:
1- In power Query, sort your percentage values descendingly, then insert an index column, then in PBI you can use the index in the measure to sum the records <= the current index, using sumx for iteration

2- Or you can create a rank measure then use it for the conditional sumx