Forum Discussion

Razaning's avatar
Razaning
Frequent Visitor
3 years ago
Solved

Summing columns with condition

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 i...
"DAX"
@need help
  • tamerj1's avatar
    tamerj1
    3 years ago

    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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

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