Forum Discussion

Anonymous's avatar
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...
Need Help
Show and Tell
  • Anonymous's avatar
    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))

     
Anonymous's avatar
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's avatar
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's avatar
    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))