Divide one matrix by another

[dsl72]

I would like to divide the results of one matrix by the results of another.  Here is what the matrices look like:

I would like to divide Demand by Capacity for each group and month (ignoring excess groups in demand, like C).  I don't care about the totals, just the individual values.  Is this possible in Power BI?

[SivaMani]

@dsl72,

Correct me if I'm wrong.

Your expectation is,

A = 52/50 = 1.04

B = 26/32 = 0.81

Right?

If it is then you just create a calculated measure to attain this.

[dsl72]

Yes, but for each group/month combination, not the totals

[SivaMani]

It will work accordingly.

[dsl72]

I'm not sure how to do the calculation for the individual combinations.  CALCULATE won't let me referene the field values directly without an operator.  When I enter the following measure:

Utilization = CALCULATE(sum(Demand[Demand])/sum(Capacity[Capacity]))

I get this result, which is correct for the row totals, but not the individual combinations:

Do I need to use a different calculation?

[v-ljerr-msft]

Hi @dsl72,

Is there any relationship between 'Demand' table and 'Capacity' table?

Could you post your table structures with some sample/mock data which can help us reproduce this issue, so that we can better assist on it? It's even better to just share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards