Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi experts, I want to create a rank measure, the rank is based on ytd amount and ordered descending,
here is the measure I created:
I also want to make the rank as a slicer, I created a column use the same code, but it signs run out of memory even I filtered raw data.
do you have a solution to create such a top x slicer? for example, when I select 50, the following table or matrix show ranked 1 to 50.
Thank you.
@oakfootballclub , You can use TOPN for That
Calculate([cal_ytd], keepfilter(TOPN(50, ALLSELECTED(fact[gpn]), [cal_ytd], desc) ) )
You can replace 50 with a selectedvalue in the slicer. You can also use the WIndow function for the same
Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.