Forum Discussion

kolturra's avatar
kolturra
Icon for Helper IV rankHelper IV
6 years ago
Solved

RANKX DAX for same category and same total in multiple rows

Hi,

 

I have below data and want to RANKX with our grouping , can some one please help me with DAX.

 

Student NamePassPercentage
AbhiRam64%
AbhiRam64%
AbhiRam64%
Adithya Vikram Singh More68%
Adithya Vikram Singh More68%
Adithya Vikram Singh More68%
Aditya88%
Aditya88%
Aditya88%

 

Thanks,
K Raghavender Rao

Need Help
Show and Tell
Tips and Tricks
  • kolturra's avatar
    kolturra
    6 years ago

    Hi,

     

    Found the answer myself. Thanks for your support.

     

    Thanks,

    K Raghavender Rao

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    Column =
    RANKX (
    'Table',
    passpercent, // or average(passpercent)
    ,
    DESC,
    DENSE
    )

    • kolturra's avatar
      kolturra
      Icon for Helper IV rankHelper IV
      6 years ago

      Hi,

       

      Below is the error what i can see.

       

      Thanks,

      R

      • kolturra's avatar
        kolturra
        Icon for Helper IV rankHelper IV
        6 years ago

        Hi,

         

        Found the answer myself. Thanks for your support.

         

        Thanks,

        K Raghavender Rao