CountIf in DAX

[lager1001]

I have two tables. I need to count the number of rows in Table 1 where Column 2 does not contain zero, and where column 1's values match the value in Table 2, Column 1. Can't get my mind around it. Been trying all sorts of combinations. Below are examples of the two tables. Table has the new calculated column I am seeking. I have connected a relationship between Table1 and Table 2 based on Column 1 in both tables.
TABLE 1

Column1​	Column 2​
ABCD​	0​
EFGH​	1​
ABCD​	1​
ABCD​	1​
ABCD​	0​
EFGH​	0​
EFGH​	0​

TABLE 2 WITH NEW CALCULATED COLUMN

COLUMN1​	NEW COLUMN ​
ABCD​	2​
EFGH​	1​

 

[cyrilbrd]

Hi, read this.

 

[lager1001]

I'm not wanting to do this in M (Power Query) but rather in PowerPivot (DAX). I have been able to formulate my CountIFs for other columns but I have not been able to find the proper DAX syntax for my original post. Still searching.

 

[lager1001]

Finally figured this out.