Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |