Forum Discussion
Helper ITwo dimension tables filtering each other
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
Solution SageHi 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