PowerBI Date table help

[Anonymous]

I have imported  2  dimension tables. I have created a date table using formula 

Dim_Date = CALENDARAUTO()

 I have disabled auto date in PowerBi desktop.

I have created a  measure for total items from table 1

I have department name in table 2.

I am looking to get a break down of count of items by department  over time using  date field in date table.  It looks fine when I add count of items and   departments. But not when I add months in year breakdown. Nothing displays as far as date.  

If I delete the relationship between date table and  other table,  data displays but  is not relative to the time period. The entire year simply has same result. 

I will appreciate any guidance. 

[parry2k]

@Anonymous Did you have created a relationship of this new calendar table with the table1?

[Anonymous]

I have created a relationship between the table transactions and the  date table.