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

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))