Is there a way to add numeric values of certain columns bast on conditions of different columns

[jj77]

For example, if column A, B, and/or C contains "4444" then combine Columns D+E+F.

Apologies, I am new to this and inexperienced with DAX funtions. Basically what I am wanting to to get is the total amount from columns D,E,F if the previous columns contain a certain number. Lets say columns A,B,C each had 4 options. Based on which ever option they pick, a quantity is entered. I want to know the total qty entered from each columns based on the individual option(s) they chose.

[DOLEARY85]

Hi,

you could use a calculated column with a nested if statement:

Column = IF('Table (9)'[A]=4444,CALCULATE(sum('Table (9)'[D]))+CALCULATE(sum('Table (9)'[E]))+CALCULATE(SUM('Table (9)'[F])),IF('Table (9)'[B]=4444,CALCULATE(sum('Table (9)'[D]))+CALCULATE(sum('Table (9)'[E]))+CALCULATE(SUM('Table (9)'[F])),IF('Table (9)'[C]=4444,CALCULATE(sum('Table (9)'[D]))+CALCULATE(sum('Table (9)'[E]))+CALCULATE(SUM('Table (9)'[F])),0)))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85]

Assuming 4444 is a number field if it's text just put it in quote marks "4444"