topic Re: Countif with DAX in Power BI Desktop in DAX Commands and Tips

Countif with DAX in Power BI Desktop

Anonymous — Wed, 19 Oct 2022 02:33:35 GMT

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

Re: Countif with DAX in Power BI Desktop

tamerj1 — Wed, 19 Oct 2022 04:06:51 GMT

Hi Anonymous

please try

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

Re: Countif with DAX in Power BI Desktop

Anonymous — Wed, 19 Oct 2022 04:31:52 GMT

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