Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm struggling with something seamingly easy. I want to show the top 20 opportunities by sales $ per region. As per attached below, when I filter the TOP N opportunities (count) it filters all the opportunities based on the top 30 sales but how could I do a nested sorting to show teh top 30 opps by sales per region?
Solved! Go to Solution.
Hi @harrinho,
I think we just need a region slicer and a filter of top N = 5. Have look at the picture. It's similar with this scenario. In the upper part, the top 5 colors will show up if we choose a brand. In the bottom of the picture, if we want to show all the top 5, it would be not that clear.
BTW, it's a measure in the bottom part.
4Measure = RANKX ( ALL ( 'Product'[Color] ), CALCULATE ( SUM ( Sales[Quantity] ) ) )
5Measure = IF ( [4Measure] <= 5, [4Measure], BLANK () )
Best Regards!
Dale
Hi @harrinho,
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Best Regards!
Dale
Hi @harrinho,
I think we just need a region slicer and a filter of top N = 5. Have look at the picture. It's similar with this scenario. In the upper part, the top 5 colors will show up if we choose a brand. In the bottom of the picture, if we want to show all the top 5, it would be not that clear.
BTW, it's a measure in the bottom part.
4Measure = RANKX ( ALL ( 'Product'[Color] ), CALCULATE ( SUM ( Sales[Quantity] ) ) )
5Measure = IF ( [4Measure] <= 5, [4Measure], BLANK () )
Best Regards!
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |