Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |