Forum Discussion

android1's avatar
android1
Post Patron
10 years ago
Solved

COUNTROWS using If OR

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 OTI...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago
    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's avatar
android1
Post Patron
10 years ago

Yes, that works. Great, thank you.

android1's avatar
android1
Post Patron
10 years ago

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?