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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello everyone!
I encountered a problem with RANKX for two measures for category of products.
One I indicator I have as a column "Turnover" and one measure Profit per Product.
I need to identify top 10 group (I have 150 groups) category by Turnover and Profit, and top 3 least too.
I made RANKX for profit and it is work. But when I tried to combime this measure with column, I have more a lot of 1 on the ranking. I think, maybe I made mistake with this calculation.
Thank you for your further answers!
is it possible to post your profit measure here? how do you calculate your profit?