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?

[Anonymous]

Hello everyone.

I just created the following measure using the TOTALYTD.

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

Now I would like to rank this, using rankx or another function, could you please help?

I just want to rank the measure using or not the ytd.

Just to be cleared I already have the ytd with rating, I just want to rank now.

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

[Anonymous]

Thank you, it worked

[Ashish_Mathur]

You are welcome.