Countif with DAX in Power BI Desktop

[Anonymous]

Dear All,

I have an Excel file, "Critical material for PBI.xlsx", with 1 sheet (Sheet1), and without any table. I have a column header "Current Status". In this column I have some status as below:
- Waiting PO
- Waiting PR
- Waiting arrival
and other.

How do I do how many records with "Waiting PO" status, I want to show the result in a card.

Thank you very much.
Prima - Indonesia

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

Count =
COUNTROWS ( FILTER ( 'Table', 'Table'[Status] = "Waiting PO" ) )

[Anonymous]

Dear tamerj1,

Thanks so much for your kindness and helping hands. 
Problem solved!

Countif Status = 
COUNTROWS(FILTER(Sheet1,Sheet1[Current Status] = "Need to issue PO"))

Just exactly the same as your suggestion. 

Thank you
Prima Indonesia