Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Nataliia_Schev
New Member

Combining measure and column in RANKX

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.

Nataliia_Schev_0-1698045900523.png

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!

1 REPLY 1
Walter_W2022
Resolver II
Resolver II

is it possible to post your profit measure here? how do you calculate your profit?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.