Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
I am hoping someone can help me becausebecause this RANKX is really giving me a run for my money. I am fairly new to Power Bi and have been teaching myself as I go and I have hit a wall with this one. I need to rank different companies average turn times (i.e. how long it took them to deliver the product from start to finish) from lowest to highest time by state. Any help is much appreciated.
Solved! Go to Solution.
Hi All,
So, my boss was able to figure it out. the correct formula to use for my case is the following:
Rank = RANKX(ALLSELECTED('2821_410_700_150'[CompanyName]), CALCULATE(AVERAGE('2821_410_700_150'[TT100150_CD])),,ASC,Dense)-1
Thank you for all your imput and assistance.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |