Star Schema Relationship + Hierarchical Dimension Tables

[MatteoGV1992]

Hello all,

I have created a PBI file utilisinsg the star Schema Model. I have 4-5 Dimension Tables and about 13 Fact Tables. All the Fact Tables have 4-5 Key columns that connect to each of the Dimension tables on a 1:Many relationship. SO FAR SO GOOD. 

The issue occurs when i need to create a 6th dimension table that actually needs to control 2 other dimension tables. Here is what I mean: 

Dimension Table 1: Item Number, Sub Brand & Brand

Dimension Table 2: Account Name

NEW DIMENSION Table: Sales Rep, Sales Manager, Sub Brand & Account.

I want to be able to select a Sales Manager and the filter needs to be applied to Dim Table 1 & 2, but because it's many to many relationship i encounter issues as well as ambiguity. Can someone help? 

Below is a screenshot of a simplified version of what I have. 

Yellow: is the New table that needs to control Address Book & Item Master

Green: are my dimension Tables

Red: are my Fact Tables

Blue are the relationships that I have currenlty created but the direction and cardinality are not what I need.

[amitchandak]

@MatteoGV1992 , The dimension should join with fact. To filter the dimension slicer of items and accounts you can use measures

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

[MatteoGV1992]

This is a great first step! but what if I want to include in my visuals the Manager & Sales Rep from the Yellow Dimension Table?