Calculated rows in matrix

[dripet84]

Hi Everyone,

I have the following matrix and i need to create a number of calculated rows that serve as subtotals and total:

How this can be done?

here is the PBI model

https://drive.google.com/file/d/1pPyWyVc3Ohbs32SZTx6Di-l_ZbrKO53o/view?usp=share_link 

Thanks

[amitchandak · Accepted solution]

@dripet84 , Refer if extended table approach can help to get the subtotal , the way I used it here

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU

[dripet84]

this is exactly what I was looking for. Many thanks