topic Re: How to get Rank values without blanks in DAX Commands and Tips

How to get Rank values without blanks

Anonymous — Fri, 05 Jun 2020 17:17:13 GMT

how to get rank values from starting from 1 when the rest values are blanks

Re: How to get Rank values without blanks

Anonymous — Fri, 05 Jun 2020 17:30:11 GMT

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)

Re: How to get Rank values without blanks

Anonymous — Fri, 05 Jun 2020 17:47:07 GMT

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

Re: How to get Rank values without blanks

Anonymous — Fri, 05 Jun 2020 17:50:27 GMT

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,

Re: How to get Rank values without blanks

Anonymous — Fri, 05 Jun 2020 17:50:59 GMT

Anonymous

Rank=

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

Re: How to get Rank values without blanks

Anonymous — Sat, 06 Jun 2020 11:21:00 GMT

Rank = if( HASONEFILTER( T[Name] ) && [Total Sales] <> 0, RANKX( FILTER( ALLSELECTED( T[Name] ), [Total Sales] <> 0 ), [Total Sales], , ASC, Dense ) )

Best

Re: How to get Rank values without blanks

Anonymous — Fri, 18 Nov 2022 08:51:59 GMT

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