I have a dimension which is a list of unique countries ("Country(unique)") with a measure of rows ("Nid" which acts as a primary key and ID for each row). Each row in my data contains a field that lists one or multiple countries ("Countries") separated by commas. I want to count the number of rows (Nid) for which each unique country appears.
Using the following formula, I am able to count the number of rows that contains (and only contains) Brazil.
Instead, I need to count all rows that contains the country and any other text/country for each country listed as a dimension. How do I go about doing this?