topic Making RANKX Measure Work ignoring blank values in DAX Commands and Tips

Making RANKX Measure Work ignoring blank values

Anonymous — Sun, 21 Jun 2020 19:33:36 GMT

Hi everyone, i've been trying to make a rankx function with this example of database

Please View the PBIX file clicking HERE

What i'm trying to do is a rank that ignores the blank values but the problem is that i'm only getting "1" value in all rows on the table visual. (If someone can explain the formular required to solve this i will appreciate it)

Thank you for reading.

Re: Making RANKX Measure Work ignoring blank values

vivran22 — Mon, 22 Jun 2020 01:36:17 GMT

Hello Anonymous ,

The file is not available on the link you have shared. Please share the file.

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

Re: Making RANKX Measure Work ignoring blank values

Anonymous — Mon, 22 Jun 2020 11:16:35 GMT

Got it, CLIC HERE

Thanks

Re: Making RANKX Measure Work ignoring blank values

Anonymous — Mon, 22 Jun 2020 11:41:13 GMT

Hi Anonymous ,

Create 2 measure

Average Sales 1 = CALCULATE(SUM(Sales[Average Sales per Day]), FILTER(Sales,Sales[Seller Name] = MAX(Sales[Seller Name])))

Rank = RANKX(ALL(Sales[Seller Name]),[Average Sales 1],,DESC,Dense)

Regards,
Harsh Nathani

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