Forum Discussion
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 en...
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).