Forum Discussion
Community Championcalculated column = count values? (sum if)
Hi vanessafvg,
The solution provided by AndrejZitnay is on the Query editor however if you want to do it in DAX you should use the following formula:
Count of Yes = IF(Table2[1] = "yes";1;0) + IF(Table2[2] = "yes";1;0) + IF(Table2[3] = "yes";1;0) + IF(Table2[4] = "yes";1;0)
Some principal different syntax.
Regards,
MFelix
Post PatronHello vanessafvg
I would maybe to some measurment but if you want that in colum than :
step 1
add 4 conditional columns and if operator equal yes than 1 otherwise 0
step 2
add all 4 conditional columns together.
- MFelix
Super User
Hi vanessafvg and AndrejZitnay,
Although the option from AndrejZitnay is correct you can make it just with one column:
(if [1] = "Yes" then 1 else 0) + (if [2] = "Yes" then 1 else 0) + (if [3] = "Yes" then 1 else 0) + (if [4] = "Yes" then 1 else 0)
Regards,
MFelix
- vanessafvg
AndrejZitnay hi that is actually a good idea but a calculate column seems less complex if i can get the logic right
- MFelix
Hi vanessafvg,
The solution provided by AndrejZitnay is on the Query editor however if you want to do it in DAX you should use the following formula:
Count of Yes = IF(Table2[1] = "yes";1;0) + IF(Table2[2] = "yes";1;0) + IF(Table2[3] = "yes";1;0) + IF(Table2[4] = "yes";1;0)
Some principal different syntax.
Regards,
MFelix
- vanessafvg
MFelix yep go it thanks
