How to count if

This measure uses the FILTER function to select only the rows in the specified column that contain the text "if". The COUNTROWS function then counts the number of resulting rows, which will give you the "if" text count in that column.