Division Formula Problem

[Anonymous]

Hello All,

Try to connect two tables to dive promo spend by shipments by Brand. How do I connect this measure to a specfic brand?

 I have posted a picture of current formula that is not working. 

 

[mattbrice]

You're missing a close parenthesis on the first SUM function.

[Anonymous]

Thank you. Here is the formula and results below. Is there a way for it idenifity each brands spend per case?

[mattbrice · Accepted solution]

wrap your entire formula in a CALCULATE() statement.