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