Multiply two matrices

[shrn]

Hi all,

I am trying to multiply two matrices in a report with each other.

I want to multiply all columns in the two matrices to the left (Boligblokker and Småhus) with the corresponding column in the right matrix, Antall boliger, So that I get two new matrices showing the number of units per TEK vs. grade (A-G) according to the percentage distribution shown in the two matrices on the left.

I'm not very experienced in power bi, so struggling a bit with how to do this. Any input or help would be much appreciated!

Thank you very much.

[v-piga-msft]

Hi @shrn，

By my test, I may not reproduce your scenario, beacuse I don't know your data model.

You could see the details about my test with the attachment which may give you some inspiration.

To get the solution, could you share the data sample and you desired output, so that we can help further investigate on it?

Best Regards,

Cherry