COUNTIF in DAX

[sanjayjob89]

             Column1  Column2

Row1      Yes          Yes

Row 2     Yes          No

In aformentioned table, I want to create Column3 with count of Yes in Row1 and Row2. How I can i achieve this in DAX?

[daXtreme]

Hi there.

This data set does not seem to be suited for analyses in Power BI. Please unpivot it and then everything will be easier.

[Whitewater100]

Hello:

Please see one solution with calc column. My table name is "Table"

Two Yes's = IF(AND('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),1,BLANK())

[sanjayjob89]

Actually I want to count number of "Yes" in row1 & row2. For the first row it'll be 2 and second row it'll be 1

[Whitewater100]

OK, you just change to OR

Two Yes's = IF(OR('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),1,BLANK())

[sanjayjob89]

Even if I change it to OR count of Yes in row1 will be 1 not 2.

[Whitewater100]

Sorry: I misunderstood.

Count Yes's = IF(AND('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),2,IF(OR('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),1))

I hope this is OK now. Thanks..

[ribisht17 · Accepted solution]

@sanjayjob89 

Step1

Coulmn1 Yes Count = IF('Sheet1 (3)'[Coulmn1]="Yes",1,0)

Step2

Coulmn2 Yes Count = IF('Sheet1 (3)'[Column2]="Yes",1,0)

Step3

Solution = 'Sheet1 (3)'[Coulmn1 Yes Count]+'Sheet1 (3)'[Coulmn2 Yes Count]

One-Step Solution

Solution=IF('Sheet1 (3)'[Coulmn1]="Yes",1,0)+IF('Sheet1 (3)'[Column2]="Yes",1,0)

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users