Forum Discussion
Solved
How to group rows with first N and other
Hello, i'm facing a problem with a report of quantities sales. I have 2 levels of row like this - Nation 1 - Customer 1 - Customer 2 - Customer N - Nation N And i need to group...
Hi Filippomonti ,
Since there is no sample data provided in the question so I can't write the code directly.However,you can refer below article for getting TopN based on the nation. It helped me and I hope it will help you as well.
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
Thanks,
Samarth
Samarth_18
Community Champion
Community ChampionIs it possible for you to share your PBIX after removing confidential data?
I figured out how to do that and unfortunately I can't share my pbix. Anyway, thank you for your kind help!
Have a nice day 🙂