Forum Discussion
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...
Hi Anonymous ,
You could create a new measure based on the "isBottom3".
_isBottom3 = SUMX ( ALLEXCEPT ( Example, Example[Seller] ), [isBottom3] )Here is the result.
Greg_Deckler v-eachen-msft https://1drv.ms/u/s!AmSmgu3y1hya6Hs21_KKtUPVBeXM?e=NAk0qA - sample file.
The expected output is described above. Thank you
Hi Anonymous ,
You could create a new measure based on the "isBottom3".
_isBottom3 =
SUMX ( ALLEXCEPT ( Example, Example[Seller] ), [isBottom3] )Here is the result.
Great! That worked! Thank you very much