In Pareto Chart small values are coming after large values for some IDs(Criteria to filter report

Harpreet_14 — Fri, 24 Nov 2023 16:47:05 GMT

Hi, I have created a pareto chart and used the following dax:

Var _total = CALCULATE(

[Total tickets]

,ALLSELECTED('public Table_Live'[Final_Group]))

Var _Current = [Total tickets]

Var _sumtable = SUMMARIZE(

ALLSELECTED('public Table_Live'),''public Table_Live''[Final_Group],"@count",[Total tickets])

Var _Cumulativesum = SUMX(

FILTER(_sumtable,[Total tickets]>= _Current),[Total tickets])

RETURN

DIVIDE(_Cumulativesum,_total)

Other Dax:

Pareto Cumulative % =

IF(

ISINSCOPE('public Table_Live'[Final_group]),

Var _AllSelectedFinalgroup = ALLSELECTED('public Table_Live'[Final_group]))

Var _FGtable = ADDCOLUMNS(_AllSelectedApp,"@Count",[Total tickets])

Var _Currentcount = [Total tickets]

Var _CumFGtable = FILTER(_FGtable,[@Count]>= _Currentcount)

Var _CumFG = SUMX(_CumFGtable,[@Count])

Var _AllSelectedFGCount = CALCULATE([Total tickets],_AllSelectedFinalgroup)

Var _Result = DIVIDE(_CumFG,_AllSelectedFGCount)

RETURN

_Result

)

For most of the Ids's Pareto chart is coming right , increasing from lowest to largest and completing at 100%

but for few client Id's Smaller Values are coming after large value.

Please help! Need Urgent help!!!

Re: In Pareto Chart small values are coming after large values for some IDs(Criteria to filter report

Fowmy — Sat, 25 Nov 2023 18:45:28 GMT

Harpreet_14

Please check your sorting.

I made a video some time back on solving such problems where there are identical values appear, please check it out: https://www.youtube.com/watch?v=8aDSztj9pmU