Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

CountIF Measure with Multiple Filter Critera

I have a table where Store Numbers are listed on the left, and then a calculated column determines whether a store is IP, IP & Analog, or Analog   IP & Analog would count both for IP and for Analog...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    Based on my test, you could refer to below measures:

    IP count = CALCULATE(COUNT(Table1[IP Analog]),FILTER('Table1','Table1'[IP Analog]="IP"||'Table1'[IP Analog]="IP & Analog"))
    Analog count = CALCULATE(COUNT(Table1[IP Analog]),FILTER('Table1','Table1'[IP Analog]="Analog"||'Table1'[IP Analog]="IP & Analog"))

    Result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

Based on my test, you could refer to below measures:

IP count = CALCULATE(COUNT(Table1[IP Analog]),FILTER('Table1','Table1'[IP Analog]="IP"||'Table1'[IP Analog]="IP & Analog"))
Analog count = CALCULATE(COUNT(Table1[IP Analog]),FILTER('Table1','Table1'[IP Analog]="Analog"||'Table1'[IP Analog]="IP & Analog"))

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He