Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi there
I am super novice and trying to convert a ranking of train stations - in this example 1 to 84 (based on their level of tree coverage) - to percentage. I.e. The highest-ranking station is 84 so his percentage ranking will be 100%. 84/84.
I just don't know how to right the DAX formula to do this?
This is how far I have come:
I have done this conversion in Excel and added the column to check if the formula works ("SCORE - Urban tree canopy coverage").
countrows(allselected(table[station precinct])
??
I have progressed slightly with this formula:
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |