Two dimension tables filtering each other

[Composed_MS]

Hello,

I have two dimension tables (Data_Country and Customers), both of them are connected with 1 to many (single cross filtering) relationship to one fact table (Ratings).

But when I put columns from dimension tables to one Table visual like below, they map with each other (means if I put Country from Data_country and Customers from Customer table in one Table visual).

Can anyone please explain why the customers gets mapped to country, as they are not directly connected and their connection with fact table (Rating) is also single cross filtering.

 

[MohammadLoran25 · Accepted solution]

Hi @Composed_MS ,

It is the default behavior. Assume you have created a measure and have added it to the table visual. Then it shows only the related combinations based on your Fact Table.

If you select one of fields (Customer or Country) and enable the option "Show Items with no data" you can see that it acts like CROSSJOIN and shows all the possible combinations of these two fields that is what you are expecting.

If this answer solves your problem, accept it as a solution so others would find what they need easier.

Regard,

Loran