Line and stacked column chart does not filter everything that's need to be filtered

[Anonymous]

So, we have the separate table "At risk parts"(no relationships with any other table) which the visual should be based on this:

And a chart that was requested should look like this (3 distinct count of projects on left axis, 3 at risk parts on right axis): 

 

"At risk parts" here is a measure based on other table(s).

The problem:
- Whenever I filter the dashboard the visual should get filtered, too. It gets, but partly. "Line values" part gets filtered fine (whenever I slice, values change as they supposed to), but the "Column Series" and "Column Values" parts of the visual stay the same. How do I get them filtered, too? Is there any DAX measure to help with? I watched a couple of videos on YouTube but didn't get it

thank you!

[lbendlin]

(no relationships with any other table)

How do you expect it to get filtered without a relationship?

[Anonymous]

And the other thing is that it has no unique values to create a relationship in the first place:(

[lbendlin]

Where I come from we call this "wash me but don't make me wet"

[Anonymous]

And how do we solve this problem with getting wet and washed?

[lbendlin]

by creating a relationship between tables where filters in one table can impact the rows in the other table.

[Anonymous]

One side gets filtered without relationships with a measure

Can't it be the case on the other?