Forum Discussion

DeanUW's avatar
DeanUW
Icon for Helper I rankHelper I
4 years ago
Solved

RankX

Trying to rank sales agents based on year to date total.  The basic DAX function    2022 GBA Rank = RANKX(ALL('Vendor Name'[Broker Full Name]), CALCULATE([2022 GBA Total]))   worked fine until I...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    DeanUW , Rank will done for a column use in Rank inside the other column present in visual (mean rank will for broker full name inside Shareholder flag )

     

    Try like

    2022 GBA Rank = RANKX(ALL('Vendor Name'[Broker Full Name], 'Vendor Name'[Shareholder flag ]), CALCULATE([2022 GBA Total]))

     

    USe summarize if the are from different tables

     

    For Rank Refer to these links
    https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

DeanUW , Rank will done for a column use in Rank inside the other column present in visual (mean rank will for broker full name inside Shareholder flag )

 

Try like

2022 GBA Rank = RANKX(ALL('Vendor Name'[Broker Full Name], 'Vendor Name'[Shareholder flag ]), CALCULATE([2022 GBA Total]))

 

USe summarize if the are from different tables

 

For Rank Refer to these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

DeanUW's avatar
DeanUW
Icon for Helper I rankHelper I
4 years ago

That worked thank you for the assist!