7 Master tables and one Transaction Table in my database.I have created common Calendar.
I have Connected all the Master tables with Transaction table by using Key fields.
Common calendar is also connected to Transaction table. when i am filtering using month dimension ,data is filtering only for the records in Transaction table for master tables.I need complete data in Master table.
Ex: I have company table if i m filter using master table i m getting 11579 company names.
same expression ,if i do filtering in Transaction table i m getting around 7000 Company names.
Sounds like you have companies in your master table without records in your transaction table. Your screenshot is meaningless without the actual data. Can you create a small document that demonstrates the problem?