Count columns with matching text

Count Rows = CALCULATE ( COUNTROWS(table_name) , TRIM('table_name'[column_name]) = "text" )