Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting bottom 3 dynamicaly

Hi, this one is a bit complicated so i'll try and explain as best as I can.  I have a table with Order ID, Seller, Ranking of price. Each order has a different number of rankings. E.g Order 1 might...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create a new measure based on the "isBottom3".

    _isBottom3 =
SUMX ( ALLEXCEPT ( Example, Example[Seller] ), [isBottom3] )

    Here is the result.