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 th...
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)

Efsteps's avatar
Efsteps
Frequent Visitor
6 years ago

Got it, CLIC HERE

Thanks 

  • 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)