Power BI Add New Rows in a Matrix

[alanuxx]

Hi Everyone ,

i created a new matrix table as you can see below .Originally in my product table there are product1,product2,product3 products .i would like to add new products (i marked yellow and green line)

Product_1_3=Product1+product3

product_2_3 = product2+product3

Can someone help me about this?

Regards,

[danextian]

Hi @alanuxx ,

I am attaching a pbix with a similar use case. In the original data, Net Income is not in the main table and is to be computed using the Revenue/Expenses/Other Expenses data. I used a disconnected table (no relationship to fact table) to hold Group names (Product Name in your case) and a measure to return the value for each.  There is also another calc table to return the Group names from the original table with an extra row for Net Income appended to it.