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

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