Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
hello.how can i rank a measure only between one to four in only one DAX?
In other word,i need to rank only top 4 measure.for this purpose,first i've created a dax:
rankx =
CALCULATE (
RANKX (
ALLSELECTED ( '1-Grouping'[city ] ),
[Selected Measure - TOP],
,
1,
DENSE
),
'3-BS'[new year] = "2017"
)and then following Dax to return only top rankx:
top rank = if( [rankx] <4 , [rankx] , blank() )
but i want to summarize them into one DAX and hence from the beginning rank only one to four of them.
Solved! Go to Solution.
You may learn to use Variables in DAX.
https://community.powerbi.com/t5/Desktop/DAX-Grouping-tagging/m-p/189391#M83354
You may learn to use Variables in DAX.
https://community.powerbi.com/t5/Desktop/DAX-Grouping-tagging/m-p/189391#M83354
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!