Show ranking from company versus peer with card

[Anonymous]

Hello All, 

I am trying to recreate the following screen shot from excel to PowerBI.

 with number in black the target KPIs number and number in red the peer group by size. 

For now I have managed to show  the following: 

Where I am showing value from the Target on the left and on the right with the following measures within a card: 

ROUNDUP(Data_Company[KPI (Median|Company)],4)*100&&IF(Data_Company[KPI (Median|Company)] > Data_Benchmark[KPI (Median|Benchmark)],"▲","▼"). 

I am having trouble to created the ranking part showing "3/29" from the screenshot above.

 I have tried using the RANKX function with to be showed in a card with the following but did no succeed to find any solution as I am not sure what metric I should create to fit into the RANKX function (e.g. summing all the KPIS would make little sense):

Ranking KPI = RANKX (CROSSJOIN( ALL(Data_Company[Company]),ALL(Data_Company[Year]),ALL(Data_Company[Size])),MEASURE TBD,,DESC)

Below an example of a table I am using as a source. Please note there are several KPIs in the same table, should I seperate them?

Any help for helping put any colors in my little arrows and to which steps I need to take to create the ranking would be appreciated.

Many thanks

[amitchandak]

@Anonymous , You rank measure should be like

Ranking KPI = RANKX ( ALL(Data_Company[Company],Data_Company[Year],Data_Company[Size]),[MEASURE TBD],,DESC)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi Amit, 

Sorry if I was not clear but the MEASURE TBD is actually the part where I struggle, as I am not sure what I need to put here. 

Please find an example of how my data looks like. I want that the card change automatically between KPI 1 and 2 depending on a filter (I managed to do all that already with a SWITCH TRUE nested function). Ideally I would like to not create an additional column for each KPI in the table as I have +40 KPIs I would like to show in the dashboard, hence why I want to work with metrics. 

Name	KPI 1 - GP as % of Revenue	KPI 2 - GPas % of Ski sales	Size	Year
A	70%	65%	EUR >50m	2020
B	56%	51%	EUR 20-50m	2020
C	68%	63%	EUR< 20m	2020
D	63%	58%	EUR >50m	2020
E	62%	57%	EUR 20-50m	2020
A	68%	63%	EUR >50m	2019
B	54%	49%	EUR 20-50m	2019
C	66%	61%	EUR< 20m	2019
D	61%	56%	EUR >50m	2019
E	60%	55%	EUR 20-50m	2019

Many thanks for your help