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.
Hi Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information? Please upload your files to OneDrive and share the link here.
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