Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I created a measure to quantify cost by salesperson.
Now, I want to use RANKX, so the lowest cost is ranked #1, not the highest cost.
So I wrote this:
Salesperson cost ranking = Rankx(allselected(table[salesperson]), table [cost])
.....but unfortunately, this gives me the highest cost as rank #1.
Any ideas ?
Solved! Go to Solution.
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
28 | |
28 | |
12 | |
12 | |
12 |