Another slicer value between two column values post

Hi AJTindall73 

You can try to add your measure into the Filter Field of your table visual and set it to show items when value =1.

I build a sample table to have a test.

Sample Table:

My YearSlicer is from 2000 to 2020.

Measure:

Measure = 
IF (
    SELECTEDVALUE ( 'YearSlicer'[Year] ) >= MAX ( 'Table'[Start Year] )
        && SELECTEDVALUE ( 'YearSlicer'[Year] ) <= MAX ( 'Table'[End Year] ),
    1,
    0
)

Result is as below.

When I select 2018, it should show values which ID = 1,2,3,6

You can download the pbix file from this link: Another slicer value between two column values post

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.