Forum Discussion
Slicer value based on column selection
Oded-Dror Unfortunately this will be a many to many relationship. You can keep your DimGeography table as is, and create a table that contains CountryID and Template and use a snowflake schema instead, so use the CountryID | Template new table related with BOTH cross filter direction to filter the DimGeography table that has a 1:many relationship SINGLE to sales and filters sales.
Oded-Dror Unfortunately this will be a many to many relationship. You can keep your DimGeography table as is, and create a table that contains CountryID and Template and use a snowflake schema instead, so use the CountryID | Template new table related with BOTH cross filter direction to filter the DimGeography table that has a 1:many relationship SINGLE to sales and filters sales.
Allison,
Thanks you for your response it call bridge table
Thanks,
Oded Dror