kpi ranking
3 Topics
Ranking based on a complex Measure
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!Solved472Views0likes1Comment
Worst Performing KPI
Hi, I have 15 different KPI data sources and I want to find the worst performing 5 KPIs in a report based on the date range. I have done an individual analysis of each KPI but I am stuck with picking the 5 worst KPIs from the 15 on a given range of dates. Any idea? Thanks JK1.1KViews0likes4Comments
