cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
murrayb8
Helper I
Helper I

Countifs Functionality workaround

Hi Im trying to use the desktop version of power bi and when using the Data tab Im trying to add a new calculated field that can calculate a countif expression.

 

So it would count the number of entries in a column (if the value in a different column equals a string of text AND the value in another column equals the adjacent cell).

 

When I use excel I can do this through a countifs() function but cant find this functionality in power BI.

 

Does anyone know of a way this can be done?

 

Thanks you very much in advance!

1 REPLY 1
Greg_Deckler
Super User
Super User

In DAX, you would use COUNTX or COUNTAX.

 

https://msdn.microsoft.com/en-us/library/ee634549.aspx

 

You can also do this by creating a calculated column that uses an if statement to return a 1 or a 0 depending on your specific criteria and then doing a simple COUNT of that column. But COUNTX is better. You could also probably get there using a CALCULATE with a COUNT expression and the right filter(s).

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.