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 this in DAX?

 

   

  • 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 

7 Replies

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

    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's avatar
      sanjayjob89
      Regular Visitor
      4 years ago

      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's avatar
        Whitewater100
        Icon for Solution Sage rankSolution Sage
        4 years ago

        OK, you just change to OR

         

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

         

  • daXtreme's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage
    4 years ago

    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.