Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |