Formula help

[Anonymous]

Hello everybody,

im looking for a measure that can do the following.

If column A contains 0 and Column B contains 1 then show me the cost that is stored in Column C.

i tried filters but that didnt give me the right outcome. Can somebody help me with this.

Kind regard,

Charaf

[Anonymous]

You didn't specifiy what your measure should do if just A is 0 or just B is 1. 

Nor did you specify what it should do if the condition is false. This should work though:

measure = if(Table[A] = 0 && Table[B] = 1;Table[C]; Table[A])

[Anonymous]

it most show the cost that is in another column. if it not match the value, dont show the cost.

@Anonymous  thanks for your helping hand.

[Anonymous · Accepted solution]

calculated column= if(Table[A] = 0 && Table[B] = 1;Table[C]; blank())

measure = calculate(sum(table[c];Table[A] = 0,Table[B] = 1))

[Anonymous · Accepted solution]

calculated column= if(Table[A] = 0 && Table[B] = 1;Table[C]; blank())

measure = calculate(sum(table[c];Table[A] = 0,Table[B] = 1))