Forum Discussion

Epter's avatar
Epter
Frequent Visitor
5 years ago

Percentages in Matrix

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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Epter
    Frequent Visitor
    5 years ago

    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's avatar
      Epter
      Frequent Visitor
      5 years ago

      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