Alternate states with a common column

[Anonymous]

I have 3 tables Products ,Customer and shops

Shops table is the connecting Products and Customers in data model.I am displaying Products details in one sheet and Customer details in other sheet with alternate states enabled but I want Shop_Name column(Used as filter in both sheets) from shop table to effect both the sheets commonly .How to implement this

[Prabhu]

Hi Krishna,

These is no issue with data model. All data is coming correctly.

Please check the attached files.kkoyyalamudi‌

[Anonymous]

Looks like issue is with your date_dim in the data model.5-JAN-18 is tied to both 2017 and 2018 years.You have to fix the date calendar.