Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Get Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous SELECTEDVALUE will not work if you choose more than one item in the slicer. You could use MAX('SelectNumber'[SelectNumber]) instead.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks Greg.

User can only select 1 value.  I tried Max as well.  Did not work.

Pic attached below.