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

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