Forum Discussion
Emulating Excel CountIfs
Community ChampionAlanMB It's just COUNTROWS( FILTER( ... ) ). No need for CALCULATE: https://www.bing.com/ck/a?!&&p=4b85c7bfe4058b3042fd2580e9e3691dbda3154ccf06d3f9900277ed5255ca6cJmltdHM9MTczNDU2NjQwMA&ptn=3&ver=2&hsh=4&fclid=2677b933-764f-6a16-3d22-ab7c779c6b62&psq=excel+to+dax+translation&u=a1aHR0cHM6Ly9jb21tdW5pdHkuZmFicmljLm1pY3Jvc29mdC5jb20vdDUvUG93ZXItQkktQ29tbXVuaXR5LUJsb2cvRXhjZWwtdG8tREFYLVRyYW5zbGF0aW9uL2JhLXAvMTA2MDk5MQ&ntb=1
Hi Greg
so I tried COUNTROWS (Filter( AB_Partner_Report ),
AB_Partner_Report[queue] = "IVR",
AB_Partner_Report[networkConnIDAB] = AB_Partner_Report[networkConnIDAB]
)
The error is now "Expression.Error: The name 'COUNTROWS' wasn't recognized. Make sure it's spelled correctly."
To be clear I am trying to add a column. A collegue has suggested adding a measure, but I am not sure how this will work as my current excel solution relies on combinng the 2 extra columns to generate a 3rd column. Can I create a new column based on 2 measures?