Forum Discussion

Srikanth5923's avatar
Srikanth5923
Regular Visitor
3 years ago

Need a DAX query help

Hi All,

 

I am new to PowerBI I have an excel file in below format need to calc league rank based on rank and multiply the 15% to get AOE Points. Can someone share DAX query for it.

 

 

TIA

Sri

Need Help

2 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    Hi Srikanth5923 ! 

    You can do this to calculate the league rank:

     

    League Rank = RANKX(ALL('Table'[Site]),CALCULATE(SUM('Table'[Rank]),ALLEXCEPT('Table','Table'[Site])),,ASC)

     

    And then,

     

    AOE Points = SUMX(VALUES('Table'[Site]),0.15*[League Rank])

     

     

     

    Hope it works!