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.
Performance = ('Table1'[KPI1]*0.2)+('Table2'[KPI2]*0.2)+('Table3'[KPI3]*0.2)+('Table4'[KPI4]*0.2)+('Table5'[KPI5]*0.2)
This is a resumed example on how the measure is built.
Each table is related to the others based on a Vendor ID linked also to a VendorTable with this same Vendor ID and other information of the vendor
The performance can give me a score from 0.00 to 1.00 based on the scores and then converted to % which means 0% to 100% overall performance.
From this point what I need to do next is to create a ranking for each vendor based on the Overall Performance score they get. I tried the following
Ranking = RANKX(ALLSELECTED('VendorsTable'[VendorName]),'Table1'[Performance]) but is giving me only 1's
also tried the following
Ranking = RANKX(ALLSELECTED('Table1'),'Table1'[Performance]) but it gives me an inaccurate ranking, I tried this way since the measure is located in Table1 even tho it brings information from several tables.
The desired output is the following.
| 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!
