Ranking by YTD Measure

[Anonymous]

Hello Everyone how are you?

I was able to create the following table with the YTD measure, but now I would like to Rank this YTD.

YTDActual = TOTALYTD(AVERAGE(Audiencia_GE_LATAM_Raking[avg_rat_per]), Datas[Date], Datas[Date] < TODAY()) 

and then I created the rank 

RnkYTD = RANKX(ALLSELECTED(Audiencia_GE_LATAM_Raking[Channels]),CALCULATE([YTDActual]))

But if I do remove one channel from the table for example the rank 1 AOT Paga, the second in the rank becomes the 1 and so go on, I do not want this to happend and there is also another thing, there are a regions collum, if i put it into the filter, the rank also changes.

Could you please help me?

[amitchandak · Accepted solution]

@Anonymous , Try with all

RnkYTD = RANKX(ALL(Audiencia_GE_LATAM_Raking[Channels]),CALCULATE([YTDActual]))

[Anonymous]

Thank you, it worked

[Anonymous]

Thank you, it worked