Different results in table view vs report view due to date table

[stampgeorge]

Hello,

I've been trying to create a report that calculates the sum of a specific column from a table with filters applied.

I've added a matrix view to compare the data between the table and report view and found out that if I use my date table, then the results are different than when I use the date from the query (Statistics) with the exact same filters (these are the correct data). 

I have 4 relations with the Statistics Query from the date table.

[Kedar_Pande · Accepted solution]

@stampgeorge 
The mismatch is likely due to inactive or multiple relationships between your date table and the Statistics table. Using Statistics[Date] bypasses the model logic. Use the date table with proper relationships and USERELATIONSHIP() in measures if needed.

[stampgeorge]

Thanks! It worked perfectly.