Forum Discussion
Problem with Pareto
Hey guys - I kindly ask for your advice. These two charts are my pareto calculation: pareto = var total = calculate(COUNT('Stammdaten Komplett'[ID] ); ALLSELECTED('Stammdaten Komplet...
- I don't quite get the code you've written but I'll tell you what you have to do. For each and every item on your x-axis you have to calculate the cumulative sum of all the items that precede the item in terms of the measure and then find all the items that have exactly the same value of the measure as the current item. Then among all the items with the same value you have to only sum up those that precede the current item plus the current item. This time the order will be not by the measure value (as they all have the same value) but by the order of the items (I guess it'll be alphabetical). This is how you properly build the pareto line.
I remember that I have seen a fully codede solution to this kind of problem on this forum. Please use the search facility to find the post by the user 'darlove'.
I don't quite get the code you've written but I'll tell you what you have to do. For each and every item on your x-axis you have to calculate the cumulative sum of all the items that precede the item in terms of the measure and then find all the items that have exactly the same value of the measure as the current item. Then among all the items with the same value you have to only sum up those that precede the current item plus the current item. This time the order will be not by the measure value (as they all have the same value) but by the order of the items (I guess it'll be alphabetical). This is how you properly build the pareto line.