Filtering a Table from Unconnected table

[arikofather]

Please see attached PBIX

https://1drv.ms/u/s!AlMdRxAveLesgegBXfqFY0rPLElZcA?e=bcP2cP

Here is my simple dataset:

Name	Days from Closed Date
A	15
B	87
C	101
D	190
E	280
F	590

I want to filter table by a Period table

Here are the expected results:

1. If Period 28 days (<= 28 days) days Selected,

Name	Days from Closed Date
A	15

2. If Period 3 Months (<= 90 days) Selected

Name	Days from Closed Date
A	15
B	87

3. If Period 1 Year (<= 365 days) is Selected

Name	Days from Closed Date
A	15
B	87
C	101
D	190
E	280

[rajendraongole1 · Accepted solution]

Hi @arikofather - When selecting a period from an unconnected table (Table B) filters the data from Table A, 

I have create a measure for selected period B 

SelectedPeriodDays =

SELECTEDVALUE('CPeriod'[Days], MAX('CPeriod'[Days]))

Create another measure that determines if the rows in Table A should be displayed based selection period as below:

ShowRows =

VAR SelectedDays = SELECTEDVALUE('Cperiod'[Days], MAX('Cperiod'[Days]))

RETURN

IF(

    MAX('CDT'[Days from Closed Date]) <= SelectedDays,

    1,

    0

)

Choose a table chart, apply the visual level filter by using a measure ShowRows is 1

add period field on report with slicer chart and select the conditions, it works as expected. please check

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!