Summing columns with condition

[Razaning]

Hey y'all!

I'm trying to sum columns with a conidion, where the value <> 4 

I tried to do the following but I didn't succeed: 

((Column A <> 4) + (Column B <> 4) + (Column C <> 4))/10

Any idea how this can be done?

Thank you

[tamerj1 · Accepted solution]

Hi @Razaning 

please try

Measur =
SUMX (
FILTER (
'Table',
'Table'[ColumnA] <> 4
&& 'Table'[ColumnB] <> 4
&& 'Table'[ColumnC] <> 4
),
'Table'[Column A] + 'Table'[Column B] + 'Table'[Column C]
) / 10