Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sanjayjob89
New Member

COUNTIF in DAX

             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?

 

   

1 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]
 
ribisht17_0-1653132776790.png

 

 

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 

View solution in original post

7 REPLIES 7
daXtreme
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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())
Whitewater100_0-1653064970026.png

 

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

OK, you just change to OR

 

Two Yes's = IF(OR('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),1,BLANK())
Whitewater100_0-1653068931250.png

 

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

Sorry: I misunderstood.

Count Yes's = IF(AND('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),2,IF(OR('Table'[Column1] = "Yes", 'Table'[Column2] = "Yes"),1))
Whitewater100_0-1653134104950.png

I hope this is OK now. Thanks..

@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]
 
ribisht17_0-1653132776790.png

 

 

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 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.