Forum Discussion

MAKOR's avatar
MAKOR
New Member
3 years ago

Pareto chart do not accumulate same value columns

Hi All,

 

In my pareto same value columns are not cumulated 😞

 

I have used measure "Pareto % defects" to create pareto line:

 

Pareto % defects =

VAR TotalDefects = CALCULATE(SUM('Defects - FoR'[Defect qty]),ALLSELECTED('Defects - FoR'))
VAR CurrentDefects = SUM('Defects - FoR'[Defect qty])
VAR SummarizedTable =
SUMMARIZE(
    ALLSELECTED('Defect type'),
    'Defect type'[Defect type],
    "Defect qty", SUM('Defects - FoR'[Defect qty])
)
VAR CumulativeSum =
SUMX(
    FILTER(SummarizedTable, [Defect qty] >= CurrentDefects),
    [Defect qty]
    )
RETURN
CumulativeSum/TotalDefects
 
Here are columns which I have used to create graph:


And corelations between them:


 

 I have looked long time to find out already solved issue but I didn't find unfortunatelly. Help please!

 

 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Add a tiny random value to each of your values to break ties.

    • MAKOR's avatar
      MAKOR
      New Member
      3 years ago

      Good advise and I'll try do so, but I'm looking for real solution instead "by-pass". Thank You for idea but how to add this tiny random value in practise in this code ?