Percentages in Matrix

Question

Hi&nbsp;I’m still struggling with getting PowerBi to display a report as I want it. My problem is I’m trying to present some finance data in a Matrix. The data is an extract from our reporting system and it contains both numbers and percentage.My Base data looks something like this and I import it to PowerBI and then I use the unpivot function to convert the data to a form that allows me to present it in a Matrix.&nbsp;This works fine for the numbers and I get a Matrix that looks like this (sorry for the blurred numbers those are real data)&nbsp;But here my problems start, I also want to present the % in the same way so I try to import a new table from the same data. This time I only take the 2 columns with the percentage, unpivot it and enter it into a new matrix. The data is presented fine but the Percentages are wrong. PowerBi adds everything together so instead of getting a result of 20% I might get 840% as it adds the 20% from each of the 42 projects.Average is not an option as it would just take the percentage and mathematically find the average. So a small project with a high profit would have the same weight as a big project with a normal profit.Project 1 Revenue &nbsp;&nbsp;100.000 - Gross profit 95.000 - Profit percentage 95%Project 2 Revenue 10.00.000 - Gross profit 2.000.000 - Profit percentage 20%So the result I get would be 57,5% and not the 20,7% that is the correct answerSo I also tried to Make a measure where I calculate the percentage and this works fine until I try and present it in the same form as above so I’m kind of stuck and hope that some of you can help me.&nbsp;&nbsp;

amitchandak · Answer

Epter , have create a measure in power bi 
divide(sum(Table[Gross Profit]), Sum(Table[Revenue]))
&nbsp;
If not you have to do this calculation as measure in power bi

epter · Answer

Thanks for the suggestion. I already tried this but i want a Matrix with both DB1 and DB2 in percentage presented in the same way as the one above. And i cannot get that part to work.&nbsp;