Forum Discussion

danning1234's avatar
danning1234
Advocate I
5 years ago
Solved

Rankx tiebreaker

Hello,

 

I have a data table, want to rank the [ExceptionTitle] by [ServiceRequestDistNb] regardless the tie by [RequestType], when respecting the [RequestTypeSort] order.

 

Example, "Orig" should be before "Admin" for always in the rank result. Base on this, rank by measure [ServiceRequestDistNb]. That means, the rank by value is the total effect of [RequestType] ASC and [ServiceRequestDistNb] DESC.

 

The number in red is the wanted result.

 

 

I have already a measure [RankByValue]. How to rank the table by this value? 

 

Here is the link to the sample file.

https://www.dropbox.com/s/mancesu0g7pe4jo/Rankx.pbix?dl=0

 

Thank you.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi danning1234 

     

    have a try

    RankByValue = 
  SELECTEDVALUE( 'Query1'[RequestTypeSort] )  * 1000
        + RANKX (
    ALLSELECTED(  'Query1'[ExceptionTitle] ),
    [ServiceRequestDistNb],
    ,
    DESC,
    DENSE
)


Test4- rank = 
RANKX (
       ALLSELECTED(  'Query1'[ExceptionTitle],  'Query1'[RequestType] ,'Query1'[RequestTypeSort],Query1[FiscalYear]),
[RankByValue],,ASC,DENSE
)

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi danning1234 

     

    have a try

    RankByValue = 
  SELECTEDVALUE( 'Query1'[RequestTypeSort] )  * 1000
        + RANKX (
    ALLSELECTED(  'Query1'[ExceptionTitle] ),
    [ServiceRequestDistNb],
    ,
    DESC,
    DENSE
)


Test4- rank = 
RANKX (
       ALLSELECTED(  'Query1'[ExceptionTitle],  'Query1'[RequestType] ,'Query1'[RequestTypeSort],Query1[FiscalYear]),
[RankByValue],,ASC,DENSE
)