Forum Discussion

JajatiDev's avatar
JajatiDev
Icon for Helper II rankHelper II
4 years ago
Solved

Pareto Chart with DAX Function

Hi, This is a follow-up to my previous query. I am trying to create a DAX function to convert the below table into a Pareto Chart.   x-axis: SC_TAT days y-axis: CountOfOrderLines   Please assi...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi JajatiDev ,

     

    Please check the formulas.

    Cumulative = SUMX(FILTER(ALLSELECTED('Table'),'Table'[SC_TAT (Days)]<=MAX('Table'[SC_TAT (Days)])),'Table'[CountOfOrderLines])
    Total = SUMX(ALLSELECTED('Table'),'Table'[CountOfOrderLines])
    Percentage = format(SUMX('Table','Table'[CountOfOrderLines])/[Total],"percent")

    Pbix as attached.

     

    Best Regards,

    Jay

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

You my be looking for this version. It's on the file upload. It's more in order of day number.

Cumulated Orders V2 =
 
VAR currorders = 'Table'[SC_TAT (Days)]
return
SUMX(
FILTER('Table',
'Table'[SC_TAT (Days)] >= currorders),
'Table'[CountOfOrderLines])
 

 

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hello:

 

Did my reply answer your initial question? Thanks..