Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Traditionally the DAX TOPN Function has a hardcoded set of n parameters. This can be useful but it's better to give our Report Consumers more flexibility in how they analyse their Business Data.
I display a nice workaround involving DAX & an additional Table- to give End Users the power to dynamically analyse their Business Insights.
In this YouTube tutorial, I'll be using some brief slides and the Power BI Desktop environment to cover:
🔥 Breaking down the Classic TOPN DAX Function within Power BI
🔥 Using DAX to display the Top Products % of Total Sales
🔥 Making our TOPN Function dynamic through Slicer Control
🔥 Using this functionality to allow End Users to make Data Driven Decisions in an instant & capitalise on their Sales data
You can watch the video using the link below:
https://www.youtube.com/watch?v=pKyCNL7Za70
Solved! Go to Solution.
Hi @Anonymous ,
It's very helpful video to solve TOPN issues. Thanks for your sharing. You also could submit it as a blog on Community Blog. 😀
And you could reply to me, then I can accept your answer as a solution. A solved post will be found more easily than an open one. Hope more PBI users can learn a lot from your video.
Thanks Xue, I will do!
Best,
James
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |