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

[Harpreet_14]

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!!!

[Fowmy]

@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