Rankx not giving correct result when data is filtered yearwise

[Anonymous]

Hello Experts,

I am having a table as below- 

Site      Year    Result

A          2014     5

A         2015      6

B         2014      3

B         2015      7

C         2014     3

C         2015     2

D         2014     1

D          2015     4

I am trying to derive the overall and yearwise ranks for the sites based on results. I am getting the correct result for overall ranks, however when i try apply the year filter, the ranks shows the wrong value.

I am using below dax for the same-

Site Ranks  = Rankx (ALL( Data[Site]), Calculate(Average(Data[Result]),ALLEXCEPT(Data,Data[Year],Data[Site])),,ASC,Skip.

Can you please help me to get the yearwise correct ranks for the same??

[lc_finance · Accepted solution]

Hi @Anonymous ,

I tried to recreate the same model as you. It works for me when I filter by year (by adding the years to my table) and shows the ranking.

Can you explain more about your problem?

Regards,

LC

[Anonymous]

Hi @lc_finance ,

Thanks for your help!! This works fine at my end..

[lc_finance]

No problem!

Glad it helped,

LC