Calculate difference between 2 categories with multiple columns in power bi

[Anonymous]

I would like to add another row called "profit" which is the difference between Margin and expense.

Sales , Margin and Expense comes from a dimension table.

[v-henryk-mstf]

Hi @Anonymous ,

Can you provide detailed data models and information for me to do further testing?  Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , if they are dimension profit need to dimension. You can not add a row below in the Matrix

But this article might help : https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223