Forum Discussion
o59393
Post Prodigy
Post ProdigyPareto 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 = [...
AhmadBakr
Helper IV
Helper IVTo 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