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

That worked in the end, apologies my system was just acting up.

 

Thanks a million for your help Ashish as per usual!!

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

You are welcome.