TopN dynamic with slicers

thelauraams — Thu, 21 Oct 2021 07:10:40 GMT

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 the slicers.

Customer	Sales
A	800
B	500
C	400
D	100
E	50

For now, my table is based on a "TOPN filter" in the filter pane. But I noticed that if I select something in the slicers at the top of the page (department, country, region etc) the TOPN will not be dynamic.

For example, if I select on my slicer country= Singapore, I would like to see the TOP5 customers in Singapore.

If I select country= Singapore and department= Asset Management, I would like to see the TOP5 customers in Singapore inside the department Asset Management.

Any recommendation please?

Many thanks!

Laura

Re: TopN dynamic with slicers

amitchandak — Thu, 21 Oct 2021 17:15:26 GMT

thelauraams , use topn with allselected

example

Top3 = calculate(sum(Table1[sales]),TOPN(3,allselected(table[Customer]),sum(Table1[sales]),DESC), values(table[Customer]))

Also, Refer

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

topic Re: TopN dynamic with slicers in DAX Commands and Tips

TopN dynamic with slicers

Re: TopN dynamic with slicers