topic Re: Summing columns with condition in DAX Commands and Tips

Summing columns with condition

Razaning — Tue, 23 May 2023 06:27:24 GMT

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

Re: Summing columns with condition

tamerj1 — Tue, 23 May 2023 17:29:26 GMT

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