A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter exp

[CarlBlunck]

Hello,

I am getting this error and unsure how to resolve.  Have tried a solution in another post but still no luck.

Original dax:

Overtime hours between = 
VAR StartHour = SELECTEDVALUE(DistinctStartingHour[Start of Hour])
VAR EndHour = SELECTEDVALUE(DistinctEndHour[End Of Hour])
RETURN
IF([StartHour] > [EndHour] ,
--calculate overtime that crosses midnight
CALCULATE([Overtime hours],
fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= TIME(23,59,0)
)
+
CALCULATE([Overtime hours],
fact_TimeCardData[STARTTIME] >= TIME(0,0,0) && fact_TimeCardData[EndTimeAdjusted] <= [EndHour]
)
+
CALCULATE([Overtime hours],
fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour
)
,
--calculate overtime that does not cross midnight
CALCULATE([Overtime hours],
fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour
))

Updated dax from solution, still not working:

Overtime hours between = 
VAR StartHour = SELECTEDVALUE(DistinctStartingHour[Start of Hour])
VAR EndHour = SELECTEDVALUE(DistinctEndHour[End Of Hour])
RETURN
IF([StartHour] > [EndHour] ,
--calculate overtime that crosses midnight
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= TIME(23,59,0))
)
+
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= TIME(0,0,0) && fact_TimeCardData[EndTimeAdjusted] <= [EndHour])
)
+
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,(fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour)
)
,
--calculate overtime that does not cross midnight
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour)
)))

Appreciate the assist.

Thanks

Carl

[CarlBlunck · Accepted solution]

This worked:

Overtime hours between = 
VAR StartHour = SELECTEDVALUE(DistinctStartingHour[Start of Hour])
VAR EndHour = SELECTEDVALUE(DistinctEndHour[End Of Hour])
RETURN
IF([StartHour] > [EndHour] ,
--calculate overtime that crosses midnight
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= TIME(23,59,0))
)
+
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= TIME(0,0,0) && fact_TimeCardData[EndTimeAdjusted] <= [EndHour])
)
+
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,(fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour))
)
,
--calculate overtime that does not cross midnight
CALCULATE([Overtime hours],
FILTER(fact_TimeCardData,fact_TimeCardData[STARTTIME] >= StartHour && fact_TimeCardData[EndTimeAdjusted] <= EndHour)
)
)

[ppm1]

There is likely a simpler way to write your measure, but this version will be more performant (it is bad practice to filter entire tables) and may address your error.

Overtime hours between =
VAR StartHour =
    SELECTEDVALUE ( DistinctStartingHour[Start of Hour] )
VAR EndHour =
    SELECTEDVALUE ( DistinctEndHour[End Of Hour] )
RETURN
    IF (
        StartHour > EndHour,
        --calculate overtime that crosses midnight
        CALCULATE (
            [Overtime hours],
            fact_TimeCardData[STARTTIME] >= StartHour,
            fact_TimeCardData[EndTimeAdjusted] <= TIME ( 23, 59, 0 )
        )
            + CALCULATE (
                [Overtime hours],
                fact_TimeCardData[STARTTIME] >= TIME ( 0, 0, 0 ),
                fact_TimeCardData[EndTimeAdjusted] <= EndHour
            )
            + CALCULATE (
                [Overtime hours],
                fact_TimeCardData[STARTTIME] >= StartHour,
                fact_TimeCardData[EndTimeAdjusted] <= EndHour
            ),
        --calculate overtime that does not cross midnight
        CALCULATE (
            [Overtime hours],
            fact_TimeCardData[STARTTIME] >= StartHour,
            fact_TimeCardData[EndTimeAdjusted] <= EndHour
        )
    )

Pat

[CarlBlunck]

Thanks Pat, unfortunately this returned really weird results....