Need to count a column based on other column

[Anonymous]

Hi Team,

I have an requirement like below.

I need to count the column "A" based on the column "B" 

• We have blank values in column "B"
• We dont have any blank values in column "A"

Out Put should be like below

column "A" should only show the count where column "B" is not blank like below, that means column "A" count should be 19 as per the below data.

Thanks in advance 

[tamerj1 · Accepted solution]

Hi @Anonymous 

try

COUNTROWS ( FILTER ( TableName, TableName[B] <> BLANK ( ) ) )