Forum Discussion

Nataliia_Schev's avatar
Nataliia_Schev
New Member
2 years ago

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.

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

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