Forum Discussion

sanjayjob89's avatar
sanjayjob89
Regular Visitor
4 years ago
Solved

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 th...
  • ribisht17's avatar
    ribisht17
    4 years ago

    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 

sanjayjob89's avatar
sanjayjob89
Regular Visitor
4 years ago

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

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

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