Forum Discussion
TopN - User selects N
Good Morning! I am trying to create a table that shows the sales of Top N stores. User selects N - via clicking on a value (e.g., 1, 3, 5, 10, ...) in a slicer / 1 col table i have created - Sele...
amitchandak
Super User
Super UserAnonymous , you need only TOPN stores?
Top 10 by duration = calculate(Sum(Table[Value]),TOPN(10,allselected(table[Store]),[Total Duration],DESC), values(table[Store]))
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks Amit.
Table pic and slicer / user selection pic attached below.