topic Re: Ranking by YTD Measure in DAX Commands and Tips

Ranking by YTD Measure

Anonymous — Wed, 16 Feb 2022 21:08:13 GMT

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?

Re: Ranking by YTD Measure

amitchandak — Thu, 17 Feb 2022 04:00:25 GMT

Anonymous , Try with all

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

Re: Ranking by YTD Measure

Anonymous — Thu, 17 Feb 2022 14:53:38 GMT

Thank you, it worked

Re: Ranking by YTD Measure

Anonymous — Thu, 17 Feb 2022 14:53:49 GMT

Thank you, it worked