How to access External Filter (Filters on this Page)

[LeoS]

Good day All.

Just wondering if someone can help me my issue.

I have created a measure that grabs the selected week in the "Filters on this Page" and put it in dim date table.

Now I created a Table using Summarizecolumns and would like to filter this using the value above but its seems it is loosing the context. Created a variable and assigned the selected week measure and include it in the table just to see the value. As my selected week measure grabs the max week (i.e 202226), when it comes to the table, it is now grabbing the max week which is wrong.

Any idea how to go about this?

[amitchandak · Accepted solution]

@LeoS , a calculated table can not take dynamic slicer/filter values

refer if needed

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

[LeoS]

Thank you. That makes sense.