Forum Discussion
CALCULATE function output incorrect result
Hi all,
I have 2 tables:
- DepartmentGroup.
- 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]))
Anonymous
Do not use calculate, it will convert each row as filter. just do it this way:
Column = SUM(DepartmentGroup[TotalTime])
2 Replies
Anonymous
Do not use calculate, it will convert each row as filter. just do it this way:
Column = SUM(DepartmentGroup[TotalTime])