Using Conditions when calculating

[pcav]

I'm sure that there is an easy answer to this one but its alluding me presently and if anybody could shed some light I would be eternally grateful.

I have 3 columns in a table, A, B and C, A contains "Y" or "N", B and C contain numerical values

I want to create a single measure that gives me the total of B and C depending on the value in A, so if A = "Y" I want to include the value in B and if A = "N" I want to include the value in C in the calculation.

I can create 2 measures filtering on each of the conditions and add them up in a 3rd measure and I get the right answer but I feel I ought to be able to do this is a single measure but the syntax alludes me. 

Peter

[alexei7 · Accepted solution]

Hi Peter,

See if the below helps you out at all (obviously replacing table and columns names with your own):

Measure = sumx(Table1,if(Table1[A]="Y",(Table1[B]),if(Table1[A]="N",(Table1[C]),0)))

Thanks

Alex 

[pcav]

Alex, works perfectly.  So simple yet I stuggled with that for hours.   Thanks so much for taking your time out to help me.  I really appreciate it

Regards

Peter

[alexei7]

Glad i could help! 🙂