topic Re: COUNTIF in DAX in DAX Commands and Tips

COUNTIF in DAX

sanjayjob89 — Fri, 20 May 2022 16:17:31 GMT

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?

Whitewater100 — Fri, 20 May 2022 16:42:58 GMT

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 — Fri, 20 May 2022 16:48:13 GMT

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

daXtreme — Fri, 20 May 2022 17:25:38 GMT

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 — Fri, 20 May 2022 17:48:59 GMT

OK, you just change to OR

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

sanjayjob89 — Sat, 21 May 2022 05:53:28 GMT

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

ribisht17 — Sat, 21 May 2022 18:11:07 GMT

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

Whitewater100 — Sat, 21 May 2022 11:56:03 GMT

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..