Correct use of || operator

[android1]

Hi,

OT(+15-15)Test =
CALCULATE(COUNTROWS ( FILTER ( OTIF, OTIF[ShiftInTime]=OTIF[TimeFrom]*[targetperc OT]||OTIF[ShiftInTime]<>OTIF[TimeFrom]*[targetperc OT] )
))

I want to multipy by [targetperc OT] if OTIF[ShiftInTime]=OTIF[TimeFrom] or OTIF[ShiftInTime]<>OTIF[TimeFrom]

My results don't change. Is the above measure sound?

[AlexChen]

Hi android1,

In your expression:

FILTER ( OTIF, OTIF[ShiftInTime]=OTIF[TimeFrom]*[targetperc OT]||OTIF[ShiftInTime]<>OTIF[TimeFrom]*[targetperc OT] )

The  OTIF[ShiftInTime] is either “=OTIF[TimeFrom]*[targetperc OT]”  or “ <>OTIF[TimeFrom]*[targetperc OT]” which definitely covers all values in OTIF[ShiftInTime] column. Please verify the logic and modify your expression.

Best Regards
Alex