Forum Discussion
calculated column = count values? (sum if)
i need to created a calcualted column that counts the columns where the value is yes
ie
column1 column2 column3 column4 calculatedcolumn
yes yes yes 3
what would be the best way to create this?
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
6 Replies
Hello 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.
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
AndrejZitnay hi that is actually a good idea but a calculate column seems less complex if i can get the logic right
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
Hello 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.
