Measure to count multiple text value from one column

[Warner]

Hi All, 

I am trying to create a measure or measures, which can give me an overall figure for each text value that appears within my dataset. 

I have one column that has a range of text values in it. Which summaries some factors that i am trying to count. 

For example: 

Client ID	Factors
1100000000	AA
1100000001	AA, AB
1100000002	AA, AB, AC
1100000003	AA

What i am trying to do is create a measure that can count all of these in one go. Instead of what i am doing now which would be: 

Test = CALCULATE(COUNTROWS('Contact data'),FILTER('Contact data','Contact data'[Factors]="AA"))

Test = CALCULATE(COUNTROWS('Contact data'),FILTER('Contact data','Contact data'[Factors]="AA, AB"))

and then creating a new measure to add these up. 

This is becasue the data has 655 rows and i dont want to have to create a measue every time a new option within the text field changes? 

So from the above example i would want the total for the measure to be 3? 

[v-yalanwu-msft · Accepted solution]

Hi, @Warner ;

You could modify it by the following:

Test = CALCULATE(COUNTROWS('Contact data'),FILTER(ALL('Contact data'),'Contact data'[Factors] in {"AA","AA, AB"}))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Test = DISTINCTCOUNT('Contact data'[Factors])