how to integrate measures into a hierarchy ?

[Anonymous]

Hello,

I would like to reproduce a P&L coming from a Database but I also want to integrate certain calculated fields into it.

For example, I want to reproduce this Excel Table in a matrix:

I had no problem reproducing the "gross margin" because it is only additions.

but iI want to add a line in the hierarchy "% External sales" ( Gross Margin / Sales - External )

My current table used to create my hierarchy is

Cat_1	Cat_2	Cat_3
Gross Margin	Sales - Financial Accounting	Sales - External
Gross Margin	Sales - Financial Accounting	Sales - Intra group

And the table with the book values look like this :

Cat_values	values	Year_Month
Sales - Intra group	5667	2024_02
Sales - External	39461	2024_02

values= sum('book_values'[values])

How could i integrate another measure without breaking the hierarchy ?

Thank you

[Anonymous]

@amitchandak I have already added the row that I want to populate in the accounts table, however I cannot do a precise calculation for this line without impacting the others which are just a sum(values).
For example, I recover the Gross margin from my accounts but I want to add a row in my P&L "Gross Margin % External Sales" which would refer to : 

Gross Margin % External Sales = CALCULATE(sum('values'[values]),'Hierarchy'[cat_2]="Gross Margin")/CALCULATE(SUM('values'[values]),'Hierarchy'[cat_4] = "Sales - External"))
The excel sheet of reference is : 

[amitchandak]

@Anonymous , When you need P&L with additional column, you have add those in account to extended account table

refer

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a