How to divide sum/sum using multiple if statements ?

[bob654321]

Below is how I'm calculating my expression.

If Label = 'A' and Client = 'X' ,Sum(Measure),

If Label = 'B' and Client = 'Y', Sum(Measure)

If Label = 'C' and Client = 'Z', Sum(measure)/If Label = 'D' and Client = 'W', Sum(measure) )))

The first 2 if statements worked perfectly but the last if statement to calculate the division is not working. It doesn't display any value on the dashboard. How can I do the sum / sum using if statements ?

[bob654321]

Marcos, is there any reason why there is a plus sign between the Sums ? The Sum(Measures) should be shown separately in each cell.