Forum Discussion

pbihelpplz's avatar
pbihelpplz
New Member
4 years ago
Solved

How to Countif Multiple Columns in PBI?

Hi everyone,

 

I am new to PBI, not sure if my question is too basic. I have a data table in this structure 

 

other fieldfield 1field 2field 3other field
 name 1nullnull 
 name 2name 1null 
 name 1name 2name 3 

 

And I want to count how many times each name appears in 3 columns (field 1/2/3), so the result (visualization) would be another table like

 

Name# of count
name 13
name 22
name 31
..........

 

I tryied COUNTA function, and add COUNTA(field1)+COUNTA(field2)+COUNTA(field3) but the result seems wrong. 

 

Much appreciate your help on this. 

 

Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi pbihelpplz 
    I assume no relationship betweem the two tables

    =
VAR CurrentName =
    SELECTEDVALUE ( Table2[name] )
RETURN
    COUNTROWS (
        FILTER (
            Table1,
            TableName[field 1] = CurrentName
                || TableName[field 2] = CurrentName
                || TableName[field 3] = CurrentName
        )
    )

5 Replies