Forum Discussion

vmaximo's avatar
vmaximo
New Member
5 years ago
Solved

COUNTROWS based on multiple critera

I am struggling to get a result for COUNTROWS based on multiple critera.   From the table DFUP I am trying to filter all Status with a grade of either “delay” and “on time” to give me the count of ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    vmaximo , It need to || not && (and)

     

    try like

    CALCULATE( COUNTROWS(DFUP), FILTER( ALL(DFUP[Status]), DFUP[Status] In{ "Delay" ,"On Time" }))

     

    or


    CALCULATE( COUNTROWS(DFUP), FILTER( (DFUP[Status]), DFUP[Status] In{ "Delay" ,"On Time" }))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

vmaximo , It need to || not && (and)

 

try like

CALCULATE( COUNTROWS(DFUP), FILTER( ALL(DFUP[Status]), DFUP[Status] In{ "Delay" ,"On Time" }))

 

or


CALCULATE( COUNTROWS(DFUP), FILTER( (DFUP[Status]), DFUP[Status] In{ "Delay" ,"On Time" }))