Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to Solution.
Step1
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
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.
Hello:
Please see one solution with calc column. My table name is "Table"
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
Even if I change it to OR count of Yes in row1 will be 1 not 2.
Sorry: I misunderstood.
I hope this is OK now. Thanks..
Step1
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
27 | |
26 | |
18 | |
15 | |
14 |