Forum Discussion
Need Help with Subtotals in Matrix
Hello,
I have created a consolidated Profit and loss in power bi for 8 entities. However I am not able to add subtotals to required fields in the report.
I need subtotal in highlighed fields in the report. How can I do that?
HI Aditya24,
Did you mean to use specific value as subtotal row to aggregate correspond values? If that's the case, you can refer to the following links to know how to use if statement to check the current row context and redirect to different calculation expressions.
Clever Hierarchy Handling in DAX - SQLBI
Regards,
Xiaoxin Sheng
2 Replies
HI Aditya24,
Did you mean to use specific value as subtotal row to aggregate correspond values? If that's the case, you can refer to the following links to know how to use if statement to check the current row context and redirect to different calculation expressions.
Clever Hierarchy Handling in DAX - SQLBI
Regards,
Xiaoxin Sheng
great thank you.!
