Calendar is not working for table 2

[Anonymous]

Hi All,

In the below table, leaves and holidays hours (measure from table1) in sync with calendar month since I have data model connecting date with calendar table. The hours changes when I change the month (calendar table).

I have populated same leaves and holidays  hours(calculated column) in table 2 which is not working as I change month and the total number hours of leaves remain same. I have connected both table 1 and table 2 with common employee ID. There is no date field to establish connection between table 2 and calendar table. Please help. 

Not working in table 2 when I change month

[Anonymous]

Hi @Anonymous ,

If I understand correctly, you created the relationship among the calendar table, table1 and table2 as below screenshot. And there is no connection between the calendar table and table2. What's the cross filter direction for these relationship? Single or Both?  If it is single, please try to change it to Both and check if the data in table2 can be filtered base on the slicer selection.

If the above one can't help you get the desired result, please provide some sample data in your tables 'table1' and 'table2' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards