how to count the records meet several condition

[yanzhao_LBS]

for example,if want to count under only one condition [PM]=FALSE ,the formular is

 COUNTAX(FILTER('Service Appointment',[PM]=FALSE),[PM])

how to count for several condition? for example ,

condition 2 is Region=Asia,

condition 3 is Response time=0

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=countrows(FILTER('Service Appointment',[PM]=FALSE&&'Service Appointment'[Region]="Asia"&&'Service Appointment'[Response Time]=0)

Hope this helps.