Display specific rank, while sometimes lower is better

[Anonymous]

Hi All, 

Currently trying to show only the ranking of a value from a certain company based on it's ranking with it's peer. I am also already using metrics and slicer to only show different KPIs. I have basically two databasis, one I am using for the calculation of the benchmark values and one for the target company. I could for now only find ranking showing the top 1/5 etc from the ranking but not a particular value. Please note that my peer group and my target are both dynamic as well with slicer. I currently only manage to show the peer group median (right hand), but I would like to show it's rankind like 7/26 for example.  Any idea on how I can achieve it?

Thanks a lot!

[Anonymous]

HI @Anonymous,

Any update for these? It seems like you want to do some custom with rank function, perhaps you can take a look at the following links about rank functions if helps:

Use of RANKX in Power BI measures - SQLBI

Showing Ranking in a Visual in Power BI using RANKX DAX function - RADACAD
Regards,

Xiaoxin Sheng

[Anonymous]

HI @Anonymous,

It seems like you did not provide enough information. Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng