DAX count function with condition

• gracebite

  Right there with Babe

  Points: 725

  More actions

  June 5, 2013 at 5:16 pm

  #294149

  How to Count a column with condition

  Example: I have to count a column A with condition value "Yes" (A="Yes") in that column

  Thank You,

  Grace

• DJTRIN

  SSC Enthusiast

  Points: 140

  More actions

  October 9, 2013 at 12:10 pm

  #1657261

  Hello Grace,

  Not sure how you if you just want a Count the number of times Yes appear in a column but hope this helps;

  =CALCULATE (Count (Table Name) [column A]), Table Name [Column A] =”Yes”)

  You need to replace the formula with your table name and column name.

  Regards,

  DJTRIN