Top 10 Sites by sum of clients

[Anonymous]

Hello! 

I have an issue with something and I cant figure it out yet (I believe it might be simpler than what I'm doing but I'm limitating myself)

I want a table to show me the top 10 sites by amount of clients it had yesterday, something similar as what TOPN as a visual filter does, but in dax level, so I have it a metric instead of a visual filter

This is my table, and I'm trying to display only the top 10 _SITIO_ by _CLIENTE UNICO_ that visited the site the day before TODAY() (I was using TODAY() -1, as a filter to achieve this), could somebody lend me a hand in how to do this?

Thanks!

[v-yalanwu-msft]

Hi, @Anonymous ;

Can you share a simple data and hope to output the results? You don't see the date column in your picture.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.