Forum Discussion

chudson's avatar
chudson
Icon for Helper IV rankHelper IV
7 years ago
Solved

Using RANKX or DAX measure to creating a ranking based on 2 calculated measures

Hi,   I'm hoping someone can help me here with ranking a report visual table.  Below is an example of the data I'm showing as a table visual in a report and I have a rankx function that ranks the d...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, chudson 

You could refer to this same post:

https://community.powerbi.com/t5/Desktop/How-to-Rank-a-list-based-on-2-values-double-rankX/td-p/44008

 

And for your case, just use this formula:

Final Rank = 
RANKX (
    ALLSELECTED(DimSalesAgent[DISTRICT]),
    RANKX(ALLSELECTED(DimSalesAgent[DISTRICT]),[% to Quota],,DESC)
        + DIVIDE (
            RANKX(ALLSELECTED(DimSalesAgent[DISTRICT]),[QTD Quota],,DESC),
            ( COUNTROWS ( ALLSELECTED(DimSalesAgent[DISTRICT]) ) + 1 )
        )
,,ASC)

Result:

 

Best Regards,

Lin

  • chudson's avatar
    chudson
    Icon for Helper IV rankHelper IV
    7 years ago

    v-lili6-msft 

    Thanks! that formula helps so much!