Divide one matrix by another

Question

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 · Answer

dsl72,&nbsp;Correct me if I'm wrong.&nbsp;Your expectation is,&nbsp;A =&nbsp;52/50 =&nbsp;1.04B = 26/32 =&nbsp;0.81&nbsp;Right?&nbsp;If it is then you just create a calculated measure to attain this.

dsl72 · Answer

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

sivamani · Answer

It will work accordingly.

dsl72 · Answer

I'm not sure how to do the calculation for the individual combinations.&nbsp; CALCULATE won't let me referene the field values directly without an operator.&nbsp; When I enter the following measure:&nbsp;Utilization = CALCULATE(sum(Demand[Demand])/sum(Capacity[Capacity]))&nbsp;I get this result, which is correct for the row totals, but not the individual combinations:&nbsp;Do I need to use a different calculation?

v-ljerr-msft · Answer

Hi&nbsp;dsl72,
&nbsp;
Is there any relationship between 'Demand' table and 'Capacity' table?
&nbsp;
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?&nbsp;It's even better to just share a sample pbix file which can reproduce the issue.&nbsp;You can upload it to OneDrive or Dropbox and post&nbsp;the link here. Do mask sensitive data before uploading.&nbsp;:smileyhappy:
&nbsp;
Regards

Forum Discussion

Divide one matrix by another

5 Replies

Related content

Divide one column by another

Divide one column by another in a matrix

Matrix divide one row by another

Divide one column by another in a matrix

Another Matrix Sum Issue