Forum Discussion

Efsteps's avatar
Efsteps
Frequent Visitor
6 years ago
Solved

Making RANKX Measure Work ignoring blank values

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. 

Help required
Help with DAX Measure
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

3 Replies

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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)