Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DAX count function with condition Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 5:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 29, 2014 11:07 AM
Points: 25, Visits: 152
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
Post #1460495
Posted Wednesday, October 9, 2013 12:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 6, 2013 6:21 AM
Points: 2, Visits: 30
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
Post #1503239
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse