Power BI Practice Solution ROUND #4 I How to apply a TOPN FILTER per category in Power BI

In this 4th Power BI Solution Round we find a way to filter the top 3 videos of trending videos on CZcams per quarter. You need to create a DAX measure that enables you to apply a TopN filter on a per category level.
Requirements:
Create a matrix visualisation with:
- Year and quarters on row together with the title field
- Create a measure that returns the total number of views in millions and add it on values.
- Create a measure that assigns a rank to the videos based on the number of views.
- Filter the matrix visualisation on the top 3 per quarter.
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[@HowtoPowerBI]

What would you like to see as a next challenge topic?

[@databoom5905]

Transpose for complex data

[@aykoshaa92]

Conditional formatting

[@marcoloeza9779]

Could you rank also the category? The intention is ranking by category and after that rank by subcategory. Btw you're amazing dude

[@badoboroten1206]

For me, you really are the best "Power BI man" on CZcams. Thank you for your work, you help me to learn a new useful world quickly and painlessly

[@pilarbaldominos2505]

The last piece has help to solve how to create a filter in numeric multiple columns that I couldn't figure out! Thanks for the inspiration... You have a new follower!

[@HowtoPowerBI]

Great to hear! and thanks for subscribing!

[@metecakmak376]

I couldn't figure out why we typed hasonevalue. A brief explanation can be so valuable for me.
Thank you for the video!

[@Amr-Ibrahim-AI]

Thanks Bas for sharing and for explaining the steps and logic in details.
This helped me.

[@cidfidchris]

Hey Bas. Amazing teaching skills!! Thanks for sharing your knowledge

[@HowtoPowerBI]

thank you so much Cedrick! that's really nice to hear

[@nikakalichava8012]

Thanks!

[@abubakrsaadmakyhoun7535]

big thanks

[@HowtoPowerBI]

😀 thanks for watching!

[@jjohn108]

This is Gold :)

[@HowtoPowerBI]

thank you!!!! 😀

[@sharmilalokhande837]

Hey Bas, I have one query, is it possible to display the details in another table visual when you click on any title.
For example
when you click on any title , details like viewer name , date etc should be display to another table visual. Thanks

[@mardithpascua8112]

i tried this and no problem except for a rows with same values, I have 15K, 15K, 20K, 21K and the ranking was 1, 1, 3, 4

[@haribharadwaj1]

That's behaving as it should isn't it? what other context does the engine have to discriminate between the two 15s ? .. Also I think your sort order is incorrect..

[@NunoGomes19]

What if I only to to show the top 1 Main Catergory? (in this video the Top Quarter).
I've tried this on one of my datasets and I created a rank measure for my main category.
If I put both rank measure on a matrix table, without any filter the output is correct for both of them, showing 1,2,3... where is suposed to be. But then, If I put the rank measure for the sub-categories on filters to only show the Top 5, the rank measure for the main category starts behaving incorrectly the the outputs change to only 1 and 2 (repetead on a bunch of main categories).
Any ideia why this happens? Thanks

[@HowtoPowerBI]

Happy to have a look. Could you send me a sample [e-mail] ?

[@Smeetr]

for me the last part of filter is not working if selection is above 5...any idea?