RankX also includes results that are not filtered

[Bene1995]

Hello,

i am working on a Formula 1 PBI and are trying to get the total rank by each season.

For that purpose i used the following measure: 

DS Rank = RANKX(ALL(drivers),MAXX(RELATEDTABLE(driver_standings__),driver_standings__[points]))

While i get results for the years driven, which are mostly correct, it also ranks years not driven. What am I doing wrong?

[hircinelol]

Hi @Bene1995 ,

You are using ALL() function, that will ignore the filters in the formula.

Try removing ALL() or using ALLSELECTED().

It it still doesn't work, please consider to use silcer and add the filter conditions to formula instead.