Percentages in Matrix

[Epter]

Hi

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.

This works fine for the numbers and I get a Matrix that looks like this (sorry for the blurred numbers those are real data)

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   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 answer

So 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.

[amitchandak]

@Epter , have create a measure in power bi

divide(sum(Table[Gross Profit]), Sum(Table[Revenue]))

If not you have to do this calculation as measure in power bi

[Epter]

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. 

[Epter]

I just tried to make the Matrix with the 2 Measures i created and added them to the values field

I get a result like this. 

The percentages are not on the right line and the i get 5 extra colums