Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dk6569
Helper I
Helper I

Count IF

I am trying to learn DAX and have read several blogs, forums etc. and I am still struggling with what I believe should be simple. I have a table that multiple columns however I need to count the number of records (Record_ID) that contain a value of "Yes" in the Flag column. 

 

Thank you in advance for you guidance. 

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

@dk6569 - did you review https://www.learndax.com/power-bi-countif-and-all-count-functions-in-dax/ ?

For your example:

countif w calculate = CALCULATE(COUNTROWS(yourTableName),yourTableName[Flag] = "Yes")





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@dk6569 - did you review https://www.learndax.com/power-bi-countif-and-all-count-functions-in-dax/ ?

For your example:

countif w calculate = CALCULATE(COUNTROWS(yourTableName),yourTableName[Flag] = "Yes")





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Thank you so much. I have not looked at that particular website but I will now. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.