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 

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.