Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello comunity, I'm needing help to create a ranking measure based on another measure that calculates data from several tables.
The report I'm working on have at least 9 different tables all conected through DirectQuery bringing data from a corporate server, each table represents data for Different KPI's determining the performance on vendors from the operation. I created the following measure to determine an Overall performance for each vendor based on the scores they get on each KPI.
Vendor | Performance | Ranking |
Jhon | 98.92% | 1 |
Roger | 87.50% | 2 |
Sara | 75.69% | 3 |
Paul | 62.34% | 4 |
If you could provide any guidance or support on how can I handle this task it will be greatly appreciated.
Thanks much!
Solved! Go to Solution.
Hello again community.
While writting this post and giving it a depper though I figured that to work properly the performance measure and the ranking needed to be located in the 'VendorsTable' and not in the 'Table1' don't know exactly why but the ranking is working properly now. The DAX sentence I ended up using is:
Hello again community.
While writting this post and giving it a depper though I figured that to work properly the performance measure and the ranking needed to be located in the 'VendorsTable' and not in the 'Table1' don't know exactly why but the ranking is working properly now. The DAX sentence I ended up using is:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |