How to count text values in Power BI like COUNTA in excel


Can anyone here help me out in finding the DAX function to count specific text values from a column? The column contains multiple values. I tried using the COUNTA function but it totals every blank field. I hope someone could help me on this.

Welcome to the forum! More than likely you need the COUNTAX function in DAX.


Also potentially you could try using the formula below to capture the specific value:

CountValues = CALCULATE ( COUNTROWS ( TableName ); TableName[ColumnName] = " This Value " )

This is some of the easier stuff you need to get your mind around early on when working with DAX.

Definitely jump into the mastering dax course when you can as this is where all these topics are covered in depth.

Good luck