Dax - Count specific value from several columns in a row

[dnhmm]

Hi, I am fairly new to Power BI and I need your help so I can get the final result on column "Count 1".

Basically I want to count how many "ones" are between "Action 1" and "Action 7" columns for the entire row.

Any suggestions would be much appreciated!

Thank you very much!

Example:

'Clients Actions'

Customer	Action 1	Action 2	Action 3	Action 4	Action 5	Action 6	Action 7	Count 1
A		1	3	3		1		2
B	1		2		6	7		1
C	7	8	3					0
D		4	7	1	2			1
E	1	3	8	1			1	3

[v-huizhn-msft · Accepted solution]

Hi @dnhmm,

Please create a calcualted column using the formula below.

Column = IF(Table1[Action 1]=1,Table1[Action 1],0)+IF(Table1[Action 2]=1,Table1[Action 2],0)+IF(Table1[Action 3]=1,Table1[Action 3],0)+IF(Table1[Action 4]=1,Table1[Action 4],0)+IF(Table1[Action 5]=1,Table1[Action 5],0)+IF(Table1[Action 6]=1,Table1[Action 6],0)+IF(Table1[Action 7]=1,Table1[Action 7],0)

You will get expected result as the screenshot shows.



Best Regards,
Angelia

[dnhmm]

Many Thanks!!