Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
This seems easy to do but all the solutions I have tried to research don't seem to work for me. All I want to do is display the top 10 rows in a table based on Exposure Gap, descending. The number of rows can change from month to month. For each month selected, I want to show the top 10 for that particular month.
Thanks for your help!
Solved! Go to Solution.
RANK =
RANKX(
ALLSELECTED( yourtable[MARG ID] ),
CALCULATE( SUM( yourtable[Exposure Gap] ) )
)
Put the measure into the visual filter
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
RANK =
RANKX(
ALLSELECTED( yourtable[MARG ID] ),
CALCULATE( SUM( yourtable[Exposure Gap] ) )
)
Put the measure into the visual filter
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi
Thanks, I've tried that but it's still displaying lots and lots of rows. Any idea what i'm doing wrong?
I'm assuming you've tried the built-in 'Top N' filtering?
Proud to give back to the community!
Thank You!
yep tried that 😞
ok figured out what the problem was. there were multiple Marg IDs in the dataset and so it was returning every row associated with that Marg ID instead of only the top Exposure Gaps
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 |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |