Display content of a table if a condition is met

[Mammm25]

I have to display content of a table if a condition is meet. For example:

[Anonymous · Accepted solution]

Hi @Mammm25 

You can refer to the following measure

The sample data 

Table 1

Table 2

Then create a measure, and put it tp the visual slicer

Measure = var a=SUMMARIZE(FILTER(ALLSELECTED('Table'),YEAR([Start])<=SELECTEDVALUE('Table (2)'[Column1])&&YEAR([End])>=SELECTEDVALUE('Table (2)'[Column1])),[Name])
return IF(ISFILTERED('Table (2)'[Column1]),IF(SELECTEDVALUE('Table'[Name]) in a=FALSE(),1,0),1)

Output

Best Regards!

Yolo Zhu

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

[lbendlin]

Create a reference table with the desired name/year combinations and join it (many to many, gasp!  but single direction) via the name column.