dax

Anonymous 

you can try TOPN

https://docs.microsoft.com/en-us/dax/topn-function-dax

or

use topN filter

Hi Anonymous ,

The problem you asked is not very clear , I hope you can give more data .

I will probably give a plan based on your needs . If you have any questions, you can continue to ask .

You can use TOPN DAX to create a table and filter the top5 of the data you want .

Column = TOPN(5,'Table','Table'[Sales],DESC)

The effect is as shown:

Or you can use the TopN function in Filters . Add the data fields in By value to filter .

Best Regards

Community Support Team _ Ailsa Tao

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