Forum Discussion

gbarr12345's avatar
gbarr12345
Post 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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

I just dragged Market to the visual and your measure seems to work

 

  • gbarr12345's avatar
    gbarr12345
    Post 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
      Super User
      2 years ago

      You are welcome.