IF OR when using COUNTROWS

android1

For CountRows, I don’t think it would work with the logical function, but we could use the logical function within the filter function.

For the situation, if you would like to have both conditions work, we could write the formula in the following format: 

On Time = COUNTROWS(

                 FILTER(

                       OTIF,

                       And([ShiftInTime]=[TimeFrom]*[ta​rgetperc OT], [ShiftInTime]<> [TimeFrom]

                               )

                             ) 

                          )

This works if both [TimeFrom]*[ta​rgetperc OT]  And [ShiftInTime]<> [TimeFrom] are true; 

The formula would be OK to write in the following way: 

On Time = COUNTROWS(

               FILTER(

                 FILTER(

                       OTIF,

                       [ShiftInTime]=[TimeFrom]*[ta​rgetperc OT]

                              ),

                  [ShiftInTime]<> [TimeFrom]

                            )

                  ) 

If you would like to use the Or function, use it in the following way: 

On Time = COUNTROWS(

                 FILTER(

                       OTIF,

                       OR([ShiftInTime]=[TimeFrom]*[ta​rgetperc OT], [ShiftInTime]<> [TimeFrom]

                               )

                             ) 

                          )

The value is TRUE if any of the two arguments is TRUE; the value is FALSE if both the arguments are FALSE. 

Adding the OR AND function reference: 

OR Function (DAX)

AND Function (DAX)

Any further assistance needed, please post back.

Regards,

Charlie Liao