DAX measure count where column values match

[foging]

Hi all!

I'm trying to count the number of rows where two different columns match and don't match.

Table 1:          

CoumnA	ColumnB
AA	BB
CC	CC
AA	AA
BB	BB
CC	BB

The answers I'm looking for here is:

Matching = 3

Not matching = 2

I've tried dofferent versions of COUNTROW but I'm simply failing on the syntax. Any ideas?

[foging]

Worked!

Thank you @tamerj1 !

[tamerj1 · Accepted solution]

Hi @foging 

COUNTROWS ( FILTER ( 'Table', 'Table'[XolumnA] =  'Table'[XolumnB] ) )

and

COUNTROWS ( FILTER ( 'Table', 'Table'[XolumnA] <>  'Table'[XolumnB] ) )