Forum Discussion

sd22's avatar
sd22
Frequent Visitor
3 years ago
Solved

DAX - RankX Function

Hi All, Can we give a custom value in RANX function so that rank starts from a particular number instead of 1 ? I want my Rank to start from 500 instead of 1. The DAX that I'm using is  i...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    3 years ago

    Hi sd22,

    How about adding 499 to your measure?

    Regards,

     

Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
3 years ago

Hi sd22,

How about adding 499 to your measure?

Regards,

 

  • sd22's avatar
    sd22
    Frequent Visitor
    3 years ago

    Hi Payeras,
    Sure 

    Regads,
    SD

  • sd22's avatar
    sd22
    Frequent Visitor
    3 years ago

    Hi Payeras,

    It worked .
    Thanks a lot!!

  • sd22's avatar
    sd22
    Frequent Visitor
    3 years ago

    Hi Payeras,

    While implmenting the logic I'm getting the below error saying "There is not enough memory to complete this operation. PLease try again later". As the table has more than 7.6 Million rows and I have also tried it through creating summarize table. The summarize table has also got more than 600K records and it shows the same error . Can you help me regarding this ?



     

     

    Regards
    SD