Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost 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
chrisu's avatar
chrisu
Icon for Responsive Resident rankResponsive Resident
10 years ago

Would it work to add an OR (||) within the filter?  It should count the rows where either of your tests are true.  

 

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