Dynamic filtering of a table based on parameter selection

[ek2112]

I have a table of tasks as follows: 

I have three parameters on my pbix file - day, month and year. I am trying to get the above table to display just those rows whose finish date is greater than the user selected date and % complete is 100. Ex: If the user selects through parameters 8/1/2019, the table should filter to show just row 10 as that is the only row as per the criteria (% complete = 100 AND finish date >  user selected date). 

Here is the link to the PBIX. I tried the CALCULATETABLE but not successful. Thanks in advance.

[v-chuncz-msft · Accepted solution]

@ek2112 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...

[ek2112]

@v-chuncz-msft  thanks for pointing me in the right direction. This gave me ideas suitable for my situation.