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 rows. 

 

This is what I have:

Number of Orders Dfup =

CALCULATE(

    COUNTROWS(DFUP),

        FILTER(

            ALL(DFUP[Status]),

                DFUP[Status] = "Delay" &&

                DFUP[Status] = "On Time"))

 

This does not come back with an error, but just displays nothing in the column.

 

Can anyone help?

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" }))

1 Reply

  • 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" }))