Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to get Rank values without blanks

how to get rank values from starting from 1 when the rest values are blanks  
DAX
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

 

Use the measure.


Rank= 

IF (NOT(ISBLANK([Total Sales)),RANKX(ALLSELECTED(Location_Date),[Total Sales,],ASC))

 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rank =

 

Var Ranky = RANKX(ALLSELECTED(Location_Data),CALCULATE([Total sales]),,ASC) Return IF(NOT(ISBLANK([Total sales])),Ranky,BLANK())

 

but still getting the same as above

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Please use the measure which I sent.

     

    Here yu have already calculated the rank in var ranky.

     

    While I am calculating rank only when Sales is not blank.

     

    Both are different.

     

    Regards,

    HN

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

       

      Rank= 

      IF (NOT(ISBLANK([Total Sales)),RANKX(ALLSELECTED(Location_Date),[Total Sales,],ASC))

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        i have use same measure but still it gaves me 1 rank for blank values i want blanks should not have any rank it should be blank