Power BI - how to count across row in multiple columns

[n2p2gupta]

Tabel example:

A  B  C  D  E  F      Total

1  0   0  0  0  0         1

1  1   1  1  0  0         4

0  0   0  0  1  1         2

0  0   0  0  0  0         0

Can you please help and provide an example how to count the value in column "Total" using DAX.  Thx.

[Eric_Zhang · Accepted solution]

@n2p2gupta

totalA = Table1[A]+Table1[B]+Table1[C]+Table1[D]+Table1[E]+Table1[F]

or you'd like to count the non-0s
totalB = IF([A]=0,0,1)+IF([B]=0,0,1)+IF([C]=0,0,1)+IF([D]=0,0,1)+IF([E]=0,0,1)+IF([F]=0,0,1)