Filtering a table based on other table values

Hi DiddyO ,

If the abbreviation of the server name in your another table that has event informations is somewhat regular, e.g., it's all the first two characters of the full spelling of name, then you can try the following:

I use this DAX to create a measure:

Measure = 
IF(
    ISFILTERED(assets[names]),
    IF(
        SELECTEDVALUE(event[names]) = LEFT(SELECTEDVALUE(assets[names]), 2),
        1,
        0
    ),
    1
)

The final output is below:

But this is only an example, your specific situation will have to ask you to provide sample data, then I can provide a more accurate solution, thank you!

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