Calculate the top records in a table so a slicer can be used

[Anonymous]

Hi, I want to be able to create a  slicer in which it only shows the top 5 of a table whose values are summed, like the table on the right, which calculates the sum of the values on the left
Can someone suggest a way to do this?

So when I hook a slicer to the table on the right, i only want the slicer to show the top 5 records and ignore the rest.

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

You can use the top n dax function.
Please refer to the linked tutorial :

https://www.youtube.com/watch?v=vpGAf6Nkt1Q

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

Thanks very much for your help on this!

[Ashish_Mathur · Accepted solution]

Hi,

Write these measures

C = sum(Data[Clicks])

Top 5 Query by clicks = calculate([c],topn(5,all(data[Query]),[c],desc),values(data[Query]))

Drag the Query column and the second measure to the table visual.

Hope this helps.

[Anonymous]

Thanks very much for your help on this!

[Ashish_Mathur]

You are welcome.

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

You can use the top n dax function.
Please refer to the linked tutorial :

https://www.youtube.com/watch?v=vpGAf6Nkt1Q

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly