Forum Discussion
Solved
Calculation Error in Measure
Hi, I have two graphs that look similar but are different. The first shows a target line of registrations with the current YTD registrations as a column below. It was changed to only show the...
Instead of VALUES('Date'[Date]) <= TODAY() you should use MIN('Date'[Date]) <= TODAY()
Headcount =
CALCULATE(
DISTINCTCOUNT(Headcount[Person Number]),FILTER(Headcount,Headcount[Termination Date]=Headcount[Headcount Month])
)
+
CALCULATE(
DISTINCTCOUNT(Headcount[Person Number]),ISBLANK(Headcount[Termination Date])
)