CALCULATE function output incorrect result

[farofiera]

Hi all,

I have 2 tables:

1. DepartmentGroup.
2. FullListDate.

The relationship between them as below:

I want to calulate the SUM of "TotalTime" of all rows using below formula:

Column = CALCULATE(SUM(DepartmentGroup[TotalTime]),USERELATIONSHIP(DepartmentGroup[ReportDate], FullListDate[FullListDate]))

But the result I have is the same value of that row:

I've also tried to remove all the filter but the result still the same.

Column = CALCULATE(SUM(DepartmentGroup[TotalTime]))

[Fowmy · Accepted solution]

@farofiera 

Do not use calculate, it will convert each row as filter. just do it this way:

Column = SUM(DepartmentGroup[TotalTime])

[farofiera]

Thanks alot Fowmy,

It was me who didn't understand how calculate works.