Forum Discussion
My total is not real in a datediff calculation
Your total is incorrect because the SUM function on your measure is summing all production dates, which skews the calculation at the total level.
Why is this occurring?
The SUM(tProcessTab[FechaProduccion]) sums all production dates and produces an unrealistic total date.
The DATEDIFF is computed on this in-correctly aggregated date.
The calculation at the row level is correct but at the Total row, it is incorrect.
How to Fix It?
Replace SUM with SUMX, which performs row by row and provides the proper total:DAX
DIFF PRO Date - MIN Slicer =
VAR StartDate = SELECTEDVALUE(tProcessTab[FechaProduccion])
VAR EndDate = MIN(CalendarioEjecuciones[Date])
RETURN
IF(NOT ISBLANK(StartDate), DATEDIFF(StartDate, EndDate, DAY))
Resolver IYour total is incorrect because the SUM function on your measure is summing all production dates, which skews the calculation at the total level.
Why is this occurring?
The SUM(tProcessTab[FechaProduccion]) sums all production dates and produces an unrealistic total date.
The DATEDIFF is computed on this in-correctly aggregated date.
The calculation at the row level is correct but at the Total row, it is incorrect.
How to Fix It?
Replace SUM with SUMX, which performs row by row and provides the proper total:
DAX
DIFF PRO Date - MIN Slicer =
VAR StartDate = SELECTEDVALUE(tProcessTab[FechaProduccion])
VAR EndDate = MIN(CalendarioEjecuciones[Date])
RETURN
IF(NOT ISBLANK(StartDate), DATEDIFF(StartDate, EndDate, DAY))
Thanks a lot, you have helped me a lot.
