calculated column = count values? (sum if)

[vanessafvg]

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?

[AndrejZitnay]

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.

[vanessafvg]

@AndrejZitnay hi that is actually a good idea but a calculate column seems less complex if i can get the logic right

[MFelix · Accepted solution]

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

[MFelix]

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]

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.