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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi jajatidev,

 

Please find attached required help,

I took your datas and saved table as Pareto.

 

After 2 measures :

cumulative =
VAR compteur =
    SELECTEDVALUE ( Pareto[SC_TAT (Days)] )
VAR result =
    CALCULATE (
        SUM ( Pareto[CountOfOrderLines] ),
        ALL ( Pareto ),
        Pareto[SC_TAT (Days)] <= compteur
    )
RETURN
    result

 

and the percentage :

cumulative percent =
VAR compteur =
    SELECTEDVALUE ( Pareto[SC_TAT (Days)] )
VAR totalorederline =
    CALCULATE ( SUM ( Pareto[CountOfOrderLines] ), ALL ( pareto ) )
VAR cumulative =
    CALCULATE (
        SUM ( Pareto[CountOfOrderLines] ),
        ALL ( Pareto ),
        Pareto[SC_TAT (Days)] <= compteur
    )
VAR result =
    DIVIDE ( cumulative, totalorederline )
RETURN
    result

 

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

Hi James,

Thanks for the quick response.

Could you please share the .pbix file for me to review because while trying to replicate I am not getting the desired result?

 

Regards,

Jajati Dev