Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Formula help

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
7 years ago
calculated column= if(Table[A] = 0 && Table[B] = 1;Table[C]; blank())
measure = calculate(sum(table[c];Table[A] = 0,Table[B] = 1))

3 Replies

Anonymous
Not applicable
7 years ago
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
  Not applicable
  7 years ago
  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
    Not applicable
    7 years ago
    calculated column= if(Table[A] = 0 && Table[B] = 1;Table[C]; blank())
    measure = calculate(sum(table[c];Table[A] = 0,Table[B] = 1))

Related content