filter of UI table as per row selcted on another UI table

[bgashok]

I have two data table and create a belwo UI in power bi. 

Trying to add another table to display item as per row selected by user in able table with work ID & Sample date.it can be blank if no row selected and  say for example when user select IT1 row, UI table -2:  need to show work items that are present as on  start , also addtional data present on End date (in between date be ignored) with ireation as IT1 and closed date can be blank or not closed before start date.

Table1 is sample of task collected on each day for duration.  planned task are all task present on start data as per iteration and not closed before sample date. 

Data table : 2

Iteration	Start Date	End Date
IT1	10/25/2023	11/7/2023
IT2	11/8/2023	11/21/2023
IT3	11/22/2023	12/5/2023
IT4	12/6/2023	12/19/2023
IT5	12/20/2023	1/2/2023
IT6	1/3/2023	1/16/2023

Table 1: 

Iteration	ID	State	Closed Date	calendar Date
IT2	312987	New	null	11/4/2023
IT2	213789	Develop	null	11/7/2023
IT2	213789	Develop	null	11/8/2023
IT2	315707	Develop	null	11/8/2023
IT2	315707	New	null	11/4/2023
IT2	315708	New	null	11/4/2023
IT2	317524	Ready	null	11/7/2023
IT2	317524	Ready	null	11/8/2023
IT2	198723	Develop	null	11/7/2023
IT2	198723	Develop	null	11/8/2023
IT2	198726	Ready	null	11/7/2023
IT2	198726	Ready	null	11/8/2023
IT2	281822	Ready	null	10/31/2023
IT2	281822	Ready	null	11/4/2023
IT2	213788	Develop	null	11/7/2023
IT2	213788	Develop	null	11/8/2023
IT2	316632	New	null	11/4/2023
IT2	316632	Ready	null	11/7/2023
IT2	316632	Ready	null	11/8/2023
IT2	315707	Ready	null	11/7/2023
IT2	315708	Ready	null	11/7/2023
IT2	315708	Ready	null	11/8/2023
IT2	281822	Ready	null	10/28/2023
IT2	312987	Ready	null	11/7/2023
IT2	312987	Ready	null	11/8/2023
IT2	317502	Ready	null	11/7/2023
IT2	314648	Ready	null	11/7/2023
IT2	314648	Develop	null	11/8/2023
IT2	314648	New	null	11/4/2023
IT2	318376	New	null	11/7/2023
IT2	318376	New	null	11/8/2023
IT2	312036	New	null	11/4/2023
IT2	312036	New	null	11/7/2023
IT2	312036	New	null	11/8/2023
IT2	312039	Develop	null	11/4/2023
IT2	315826	Develop	null	11/7/2023
IT2	315826	Develop	null	11/8/2023
IT2	315826	New	null	11/4/2023
IT2	312039	Develop	null	10/28/2023
IT2	312039	Develop	null	10/31/2023
IT2	312036	New	null	10/28/2023
IT2	312036	New	null	10/31/2023
IT2	314648	New	null	10/31/2023
IT2	297455	Ready	null	11/8/2023
IT2	198727	Ready	null	10/28/2023
IT2	198727	Ready	null	10/31/2023
IT2	198727	Ready	null	11/4/2023
IT2	198727	Ready	null	11/7/2023
IT2	198727	Ready	null	11/8/2023
IT2	319362	New	null	11/8/2023
IT2	312987	New	null	10/31/2023
IT4	317502	Ready	null	11/8/2023
IT2	297451	Develop	null	11/7/2023
IT2	297451	Develop	null	11/8/2023
IT1	313293	Develop	null	10/28/2023
IT1	313293	Develop	null	10/31/2023
IT1	313293	Develop	null	11/4/2023
IT1	313284	Develop	null	10/28/2023
IT1	313284	Develop	null	10/31/2023
IT1	313284	Done	null	11/4/2023
IT1	312039	Ready	null	10/25/2023
IT1	313284	Develop		11/7/2023
IT1	313284	Closed	11/5/2023	11/8/2023
IT1	313281	New	null	10/28/2023
IT1	313281	Develop	null	10/31/2023
IT1	313281	Develop	null	11/4/2023
IT1	313296	Develop	null	10/31/2023
IT1	313296	Develop	null	11/4/2023
IT1	313296	Closed	11/7/2023	11/7/2023
IT1	313296	Closed	11/7/2023	11/8/2023
IT1	311563	Ready	null	10/25/2023
IT1	311563	Develop	null	10/28/2023
IT1	311563	Develop	null	10/31/2023
IT1	311563	Develop	null	11/4/2023
IT1	312036	New	null	10/25/2023
IT1	313296	New	null	10/28/2023
IT1	311563	New	null	10/24/2023
IT1	311563	Closed	11/7/2023	11/7/2023
IT1	311563	Closed	11/7/2023	11/8/2023
IT1	312015	Ready	null	10/25/2023
IT1	312015	Develop	null	10/28/2023
IT1	312015	Develop	null	10/31/2023
IT1	312015	Closed	11/2/2023	11/4/2023
IT1	313325	Develop	null	11/4/2023
IT1	313293	Closed	11/6/2023	11/7/2023
IT1	313293	Closed	11/6/2023	11/8/2023
IT1	312015	Closed	11/6/2023	11/7/2023
IT1	312015	Closed	11/6/2023	11/8/2023
IT1	313325	Closed	11/7/2023	11/7/2023
IT1	313325	Closed	11/7/2023	11/8/2023
IT1	198726	Ready	null	10/25/2023
IT1	198726	Ready	null	10/28/2023
IT1	198726	Ready	null	10/31/2023
IT1	198726	Ready	null	11/4/2023
IT1	198723	Develop	null	10/31/2023
IT1	198723	Develop	null	11/4/2023
IT1	311583	Closed	11/5/2023	11/7/2023
IT1	311583	Closed	11/5/2023	11/8/2023
IT1	311583	Ready	null	10/25/2023
IT1	311583	Ready	null	10/28/2023
IT1	311583	Ready	null	10/31/2023
IT1	311583	Done	null	11/4/2023
IT1	198723	Develop	null	10/25/2023
IT1	198723	Develop	null	10/28/2023
IT1	213788	Ready	null	10/31/2023
IT1	306649	Develop	null	10/25/2023
IT1	306649	Develop	null	10/28/2023
IT1	306649	Develop	null	10/31/2023
IT1	306649	Develop	null	11/4/2023
IT1	306649	Develop	null	11/7/2023
IT1	306649	Develop	null	11/8/2023
IT1	306649	New	null	10/24/2023
IT1	213789	Ready	null	10/28/2023
IT1	213788	Develop	null	11/4/2023
IT1	313281	Closed	11/7/2023	11/7/2023
IT1	313281	Closed	11/7/2023	11/8/2023
IT1	213789	New	null	10/25/2023
IT1	213788	New	null	10/25/2023
IT1	198727	Ready	null	10/25/2023
IT1	311583	New	null	10/24/2023
IT1	281822	Ready	null	10/25/2023
IT1	297451	Ready	null	10/25/2023
IT1	297451	Develop	null	10/28/2023
IT1	297451	Develop	null	10/31/2023
IT1	297451	Develop	null	11/4/2023
IT1	213789	Ready	null	10/31/2023
IT1	213789	Develop	null	11/4/2023
IT1	213788	Ready	null	10/28/2023
IT1	297451	New	null	10/24/2023
IT1	281822	New	null	10/24/2023
IT1	314650	Closed	11/5/2023	11/7/2023
IT1	314650	Closed	11/5/2023	11/8/2023
IT1	313288	Closed	10/30/2023	10/31/2023
IT1	313288	Closed	10/30/2023	11/4/2023
IT1	313288	new		11/7/2023
IT1	313288	Closed	10/30/2023	11/8/2023
IT1	279821	Closed	11/5/2023	11/7/2023
IT1	279821	Closed	11/5/2023	11/8/2023
IT1	279821	Develop	null	11/4/2023
IT1	314650	Develop	null	10/31/2023
IT1	314650	Develop	null	11/4/2023
IT1	313288	Done	null	10/28/2023
IT1	312045	Ready	null	10/25/2023
IT1	312045	Ready	null	10/28/2023
IT1	312045	Develop	null	10/31/2023
IT1	312045	Closed	11/2/2023	11/4/2023
IT1	312045	Closed	11/2/2023	11/7/2023
IT1	312045	Closed	11/2/2023	11/8/2023
IT1	313325	Ready	null	10/28/2023
IT1	313325	Ready	null	10/31/2023
IT1	281822	Closed	11/7/2023	11/7/2023
IT1	281822	Closed	11/7/2023	11/8/2023
IT3	213790	New	null	11/4/2023
IT3	213790	New	null	11/7/2023
IT3	213790	New	null	11/8/2023
IT3	213791	New	null	11/4/2023
IT3	213791	New	null	11/7/2023
IT3	213791	New	null	11/8/2023
IT3	312039	Ready	null	11/7/2023
IT3	312039	Ready	null	11/8/2023

[bgashok]

Thankyou @amitchandak 

[amitchandak · Accepted solution]

@bgashok , Try a measure like

FilteredItems =
VAR SelectedIteration = SELECTEDVALUE(DataTable2[Iteration])
VAR StartDate = CALCULATE(MIN(DataTable2[Start Date]), DataTable2[Iteration] = SelectedIteration)
VAR EndDate = CALCULATE(MAX(DataTable2[End Date]), DataTable2[Iteration] = SelectedIteration)
RETURN
IF(
ISBLANK(SelectedIteration),
BLANK(),
CALCULATE(
COUNTROWS(Table1),
Table1[Iteration] = SelectedIteration,
Table1[Calendar Date] >= StartDate,
OR(Table1[Closed Date] >= StartDate, ISBLANK(Table1[Closed Date]))
)
)