Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I created the following table in the “Report” view of Power BI, and used the RANKX function to determine the risk ranking:
Table
Measure
RANK = rankx(ALLSELECTED(TD[RISK]),[Q])
Then, I would like to have 1 card showing the risk with ranking 3, that is, the "alcohol" risk, like this:
How could I propose the measure to obtain this result?
Thank you
Solved! Go to Solution.
Hi,
Try this measure
=calculate(max(TD[Risk]),filter(values(TD[Risk]),[Rank]=3))
Hi,
Try this measure
=calculate(max(TD[Risk]),filter(values(TD[Risk]),[Rank]=3))
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! |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |