Forum Discussion

android1's avatar
android1
Post Patron
10 years ago

IF OR when using COUNTROWS

Hi,   I'm need to modify the measure On Time = COUNTROWS(FILTER(OTIF,[ShiftInTime]=[TimeFrom]*[targetperc OT])) to also COUNTROWS if [ShiftInTime]<> [TimeFrom]   Thinking IF OR but don't know ho...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

I checked your data, the reason why the OT %won’t work, is because your measure having issue calculating OT(+ 15 -15):

 

OT(+15-15) =

COUNTROWS ( FILTER ( OTIF, OTIF[Punctuality] = "On Time" ) )

 

[On time] is a measure,  and should be write in a format of [On Time], which is the only measure that uses the OT % column; and OTIF[Punctuality] is in text type, when comparing those two values, it will generating errors under the visuals.

I think you might need to re-consider how to calculate the OT(+15-15) value here.

android1's avatar
android1
Post Patron
10 years ago

Hi Charlie Lao,

 

I've changed my OT measure to OT(+15-15) =
CALCULATE(COUNTROWS ( FILTER ( OTIF, OTIF[ShiftInTime] = OTIF[TimeFrom]*[targetperc OT]||OTIF[ShiftInTime] <> OTIF[TimeFrom]*[targetperc OT] )
))

 

Data still not changing when value selected in OT slicer. I was sure this would work.

 

https://www.dropbox.com/s/r5uuuchxj1dx4zv/OTIF%20Sample.pbix?dl=0