Cross filtering Report filters

I am using DirectQuery with SQL Server database, which is not star schema. I know Cross Filtering is not available with DirectQuery.

This is the reason why I am looking for a workaround.

I am building a lot of indicators, and for each of them, I want to be able to filter according to the same columns. Here is the (simplified) schema in Power BI:

I am filtering by Customer and Region. This is easy. But I also want to be able to filter by Agent name.

I am talking about Report filters.

And as you can see on the schema, the link is in the other direction between APPOINTMENT and AFFECTED_AGENT.

So of course, if my indicator is based on the APPOINTMENT query, the event of filtering the agents won't affect the indicator.

What are the workarounds to do this?

Thank you in advance.