Use The date selected in the page filter to use it as a filter in another query

[AbdelrahmanAyad]

Hey Guys , I have a requirement and I am somehow new to powerbi. 

I am doing a dashboard for a constructions company. The data model is as below

This is how the data in the project progress looks like.

The user selects the As of date in powerbi from a list. 

So I want to check the projects that have status Active at this date and use these project ref to filter all my calculations. I came up with a DAX formula as follow : 
Measure X = CALCULATE(SUM('Approved Variations'[Amount]), FILTER('Approved Variations' , 'Approved Variations'[Project Ref] IN (

VAR M = FILTER('Project Progress', 'Project Progress'[Project Status] <> "Non-Active" && 'Project Progress'[As of Date] = SELECTEDVALUE('Calendar'[Date]))
RETURN SELECTCOLUMNS(M,"Project Ref", 'Project Progress'[Project Ref])

When I use selected values it does not work however if I replaced SelectedValue with a static value like this one : DATE(2017/12/31) It works So any clues or ways to let this work?? 

Thank You very much

[v-yulgu-msft]

Hi @AbdelrahmanAyad,

Have you tried my suggestion in an older post? Does it work in your scenario?

By the way, do mask sensitive data before uploading, including your personal account.

Regards,
Yuliana Gu