Making RANKX Measure Work ignoring blank values

[Efsteps]

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. 

[vivran22]

Hello @Efsteps ,

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

[Efsteps]

Got it, CLIC HERE

Thanks 

[harshnathani · Accepted solution]

Hi @Efsteps ,

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)