Forum Discussion

SN1900's avatar
SN1900
Frequent Visitor
6 years ago

count if function

Hi all, 

 

I want to build a Count if  function in Power BI but I am struggling a little bit as I do not find the correct formular. 

 

I have a column named ("Time Window Performance") which categories the  whole "table1"  into "Delivered on Agreed time" "too early" and "too late".  

 

Now I want to count only  the categorie "Delivered on Agreed time". 

 

In Excel it would be. 

=Countif( Time Window Performance = "delivered on agreed Time") 

 

Thanks and best regards 

 

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You can do it as below:

    TableName count = COUNTROWS( 'TableName', FILTER( 'TableName', TableName[Time Window Performance] = "delivered on agreed Time" ) )

    Thanks.