Division two columns with a filter

Question

Hi, how can I divide the cost over the QTY and filter chairs category from the equation? Thank you!

daxtreme · Answer

[New Field] = // calc column
    divide(
        T[Cost],
        T[QTY] * ( T[Material] &lt;&gt; "chairs" )
    )

Forum Discussion