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.
Solved! Go to Solution.
@Anonymous
Try a workaround with a measure to show TOP N in your data. Check more details in the attached pbix.
Measure = IF(CONTAINS(TOPN(2,ALLSELECTED('Table'),'Table'[val],ASC),'Table'[id],MAX('Table'[id])),MAX('Table'[id]),BLANK())
Why both topn and rankx are not supported in my version? I got the same error.
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 |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |