Filter trigger other filters on different dimension/tables

[LS69]

Hello im brand new in Power BI. I have a problem how to manage an issue in PowerBI.

Scenario: i have 3 different tables/dimensions(unrelated in Model) in which i have one field in each table that's act like the same filter(one for each table). That i want to do is when i click on one of the filter in one table then i want it to effect(trigger) the other two tables. 

For example

TableA Departments  North

                                   Middle

                                   South

TableB Department    North

                                   Middle

                                   South

TableC Department    North

                                   Middle

                                   South

When i for example click and choose on TableA Department "Middle" i want it to select Department Middle in TableB and the same for TableC.  

Is this possible? - thru filters or doing some DAX? - idont have the possibility to add tables or columns.

Please give me an hint what or how i cant solve this.

thank you in advance!

//L

[MohammadLoran25 · Accepted solution]

Hi @LS69 ,

Follow steps below:

1-Creating a measure:

DepartmentFilterMeasure =
SUMX (
    FILTER (
        CROSSJOIN ( TableA, TableB, TableC ),
        TableA[Departments] = TableB[Departments]
            && TableA[Departments] = TableC[Departments]
    ),
    1
)

2-Putting this measure at your visuals separately as greater than 0:

If this answer solves your problem, please give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran