Forum Discussion

ek2112's avatar
ek2112
Advocate II
7 years ago
Solved

Dynamic filtering of a table based on parameter selection

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.