topic Re: DAX function to count values in column in DAX Commands and Tips

DAX function to count values in column

EmilyM2019 — Thu, 10 Oct 2019 13:58:58 GMT

Hi all,

I have a column that contains various rows of different text, some of the rows say "Overdue" some say "Not due" some are blank.

How do I create a DAX formula to count all the Overdue rows?

Sorry totally new to this.

TIA Emily.

Re: DAX function to count values in column

Nathaniel_C — Thu, 10 Oct 2019 14:09:50 GMT

Count = CALCULATE(Countrows(Table),Table[Column]="Overdue")

Hi EmilyM2019 ,

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Re: DAX function to count values in column

EmilyM2019 — Thu, 10 Oct 2019 14:22:45 GMT

Awesome, thanks so much.

Re: DAX function to count values in column

Anonymous — Mon, 30 May 2022 15:19:55 GMT

What about to count "overdue" and "not due" both?

Re: DAX function to count values in column

Nathaniel_C — Mon, 30 May 2022 15:32:55 GMT

Hi Anonymous ,
Please try this:

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Count = CALCULATE(Countrows(overdue),overdue[Column1]="Overdue" || overdue[Column1]= "Not overdue")

Re: DAX function to count values in column

walsamoht — Sun, 17 Jul 2022 06:20:07 GMT

I am a new user of Power Bi and you are a star to solve my issue of not having countif in Power BI.