Forum Discussion

BEC_100's avatar
BEC_100
Frequent Visitor
3 years ago
Solved

Multiple Citeria Measure

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

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    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.