Filtering Measure by last the rankn before

[LuisApollo]

Good Afternoon :
I have created a measure called % Agt talk time and I need to show the last week result of this measure .
To achieve this i ve created a week ranking , so I need to filter upon selecting a FIXweek (i.e week 3 ) the results for the week rank 53 .
I can´t use last week due to the change of year and sepciall weekly requests , so the ranking made sense for me, however the measure is not working. Any help to achieve this ? The results will be filteres by year - Week 

Used Measure :

LW % agt Talk Time = CALCULATE([% Agt Talk time],

FILTER(ALL(statCallEnd[WeekRank]), statCallEnd[WeekRank] = (SELECTEDVALUE(statCallEnd[WeekRank])-1)))

[LuisApollo]

Will build a new date table and work from there , will let you know if that works

[amitchandak]

@LuisApollo , Make sure you have a separate date or week year table and in visual you use week year from that table only

try measures like

This Week = CALCULATE([% Agt Talk time], FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE([% Agt Talk time], FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

[LuisApollo]

Well, built a time table and made the Measure , it does help since i can see the last fomr selected , however it doesn´t populate a table and only works if one value is selected 

Very close but still missing something