Forum Discussion

EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago
Solved

DAX function to count values in column

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...
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago
    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

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago
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

  • EmilyM2019's avatar
    EmilyM2019
    Helper II
    6 years ago

    Awesome, thanks so much.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

    • Nathaniel_C's avatar
      Nathaniel_C
      Community Champion
      4 years ago

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

       

  • walsamoht's avatar
    walsamoht
    Regular Visitor
    4 years ago

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