Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Ranking by YTD Measure

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?
 
GuiGentil_0-1645045353783.png

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Try with all

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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Try with all

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

Anonymous
Not applicable

Thank you, it worked

Anonymous
Not applicable

Thank you, it worked

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors