Ranking KPI

[GeorgeEard]

Hi,

Does anyone know why every partner (FW Account Name (report name)-Partner) I select is giving the rank of 1 in my KPI?

I'm using the formula : =aggr(rank({<[FW Account Name (report name)-Partner]>}(Scores)),[FW Account Name (report name)-Partner])

where 'scores' is a master measure and Partners are being ranked so that when selected the partner with the highest score will be 1 on the KPI and the lowest will show 51

I am thinking it currently is because when i select a partner all other scores are filtered out, any idea how to stop that?

Scores:

[Chanty4u]

Try this 

=Aggr(

    Rank( {< [FW Account Name (report name)-Partner] = >} Scores ),

    [FW Account Name (report name)-Partner]

)

[GeorgeEard]

Hi thank you for your reply,

However unfortunately it is still returning every partner as 1.