many-to-many relations and visualization cross-filtering issue

[motagaly]

Dears,

I've imported a database form MS Access where I have many to many relationship as below, the problem is once I use this data in visualizations , the cross-filtering is not working any more when I click on any visualizaiton that touches this many-to-many visualization (in my case it is a Treemap)

Data Model
Divisions - Objectives (Divisions can have many Objectives and Objectives can be linked to one or more Divisions)

Table-Divisions
DivID (PK)
DivName
Comments

Table-Objectives
ObjID (PK)
ObjName
Comments

Table-DivisionObjectives (m-m table), there is a constraint that both below are primary keys and can't be duplicated
DivID (PK)
ObjID (PK)


Data Model
I've created and extended column the m-m table (Table-DivisionObjectives) to get the Division Name from the Divisions table and to get the Objective Name form the Objectives Table)

Visualization
Treemap on the m-m table (Table-DivisionObjectives) grouped by Division Name and the value = Count of Objective Name

Issue
Other visualizations are not filtered (cross-filtering) when I click on a specific Division on the Treemap visualization (as highlighted in yellow above)