The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |