Forum Discussion

gbarr12345's avatar
gbarr12345
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Bottom 5 Sales by Market Measure

Hi there,   I'm looking to create a measure to get the bottom 5 sales by Market without needing the use of slicers/ filters.   Is it possible to do this with a measure as I can do the top 5 but I...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi gbarr12345 
    You can use a measure :

    Bottom_5 =
    Var
    Rank_market = RANKX(ALLSELECTED('Dimension_Market Table'[Market]),[total_sales],,ASC,Dense)
    RETURN
    IF(Rank_market>0 &&Rank_market<6,[total_sales],BLANK())

     

    pbix is attached
     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

     

gbarr12345's avatar
gbarr12345
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi Rita,

 

Thank you for your response.

 

I tried your measure and it's showing as blank for me. Any idea why this is happening?

 

 

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

I can't know without seeing the pbix.
Please download the file that I attached in the first reaction and follow my steps.

If it still doesn't work, attach yours with the problem....

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.