Date table not working

[Anonymous]

I built an SSAS Tabular model cube and created a date table using calendarauto. I have marked it as a date table and created a relationship with the fact table using the date column, and both columns have a Datetime data type.
When I analyze the data using excel, the date filter is not working correctly. For example, when I filter on the year 2021, it gives me row values for the year 2019 also, but if I use the date column from the fact table, I get the correct results.
When I analyze the Tabular cube using Power BI, it works right.
Could you please suggest what exactly is going wrong with our date table?

Thanks in advance.

[Anonymous · Accepted solution]

 When Analyzing the data on Excel using only attributes generates cross join, so now I understand that I should add a measure to my table.

[Fowmy]

@Anonymous 


Can you try replacing the calendarauto function with the CALENDAR function?

Example:
CALENDAR ("01/01/2019" , "31/12/2021" )

[Anonymous]

I still get the same results( values from the year 2019) when filtered by 2021.