Count if a cell is not blank, and matches an adjacent cell

[akeener1]

Example Table

Column 1	Column 2
First	First
Second	Second
Third	Third
	Fourth
Fifth	Fifth
Sixth
Eighth	Eighth

So, what I am trying to do is Count all the cells in column 1 that are NOT blank AND match the adjacent cell in Column 2.

In this case, the total count should be 5. I use SumProduct in Excel to achieve this, but I have no idea how to create this in Power BI as I am still a baby user.

[amitchandak · Accepted solution]

@akeener1 , A measure like

countrows(filter(Table, not(isblank(Table[Column 1])) && not(isblank(Table[Column 2]))) )