Multiple Citeria Measure

[BEC_100]

Hello experts.

I have a table that contains data in following format

Build   ver      Color

12           1.0.1    blue

12           1.0.3    red

13          2.0.4    blue

13          2.0.5    orange

12          3.0.2    blue

I want to create a measure that if is ‘12’ and ‘blue’, it will filter only

12           1.0.1    blue

12          3.0.2    blue

This works for only one criteria

Measure = COUNTROWS(FILTER(UnifiedInstallers,UnifiedInstallers[Color]="blue")) but I need the Build too.

Any help is greatly appreciated

[v-jingzhang · Accepted solution]

Hi @BEC_100 

You can use && to concatenate multiple criteria. For example, 

Measure =
COUNTROWS(FILTER(UnifiedInstallers,UnifiedInstallers[Color]="blue" && UnifiedInstallers[Build]="12"))

If the Build column is Number type, remove the double quotes around 12. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.