COUNTROWS using If OR

[android1]

Hi,

How would I modify the following measure - OnTime =
CALCULATE(COUNTROWS ( FILTER ( OTIF, OTIF[ShiftInTime] = OTIF[TimeFrom]*[targetperc OT])))

to also multiply by [targetperc OT] if OTIF[ShiftInTime] <> OTIF[TimeFrom]

[Greg_Deckler · Accepted solution]

OnTime = 
CALCULATE(COUNTROWS ( FILTER ( OTIF, OTIF[ShiftInTime] = OTIF[TimeFrom]*[targetperc OT])) + COUNTROWS ( FILTER ( OTIF, OTIF[ShiftInTime] <> OTIF[TimeFrom]*[targetperc OT])) * [targetperc OT]   )

Something like that?

[android1]

Hi,

When I try to get the percentage of your measure of Total Calls ie. OnTime % = OnTime/Total Calls

the OnTime% changes to whatever value is selected in the slicer. Any idea why this is?

[android1]

Yes, that works. Great, thank you.

[android1]

Hi,

When I try to get the percentage of your measure of Total Calls ie. OnTime % = OnTime/Total Calls

the OnTime% changes to whatever value is selected in the slicer. Any idea why this is?