Forum Discussion

molvera's avatar
molvera
Regular Visitor
8 years ago

Pareto Chart Issue independent Ranking

Hi.

 

I have read other posts about pareto charts using ranking function, does anyone has ever had the issue in which racking is the same because of equal leyend values? I'm measuring customer satisfaccion. 

 

Cummulative % is a being added acordingly to the ranking but it need to make rakings unike regarless that I have leyends with the same value.

 

this is the DAX formula im using Rank = if(HASONEVALUE(Encuestas1[Cliente]),rankx(all(Encuestas1[Cliente]),[Total Sales]),blank())

 

thanks in advanced

 

 

 

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi molvera,

     

    Modify your measure like below and check if it can meet your requirement.

     

    Rank =
IF (
    HASONEVALUE ( Encuestas1[Cliente] ),
    RANKX ( ALL ( Encuestas1[Cliente] ), [Total Sales],,, DENSE ),
    BLANK ()
)

    If your issue still happens, could you clarify more details about measure [Total Sales]?

     

    Regards,

    Jimmy Tao