Forum Discussion
TopN dynamic with slicers
Hi all! I am facing an issue to make my TOP5 table dynamic with my slicers. I want to display the TOP5 customers based on sales, but I need that table to be dynamic depending on the selection of...
amitchandak
Super User
Super Userthelauraams , use topn with allselected
example
Top3 = calculate(sum(Table1[sales]),TOPN(3,allselected(table[Customer]),sum(Table1[sales]),DESC), values(table[Customer]))
Also, Refer