Need Help with Subtotals in Matrix

[Aditya24]

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?

[Aditya24]

great thank you.!

[Anonymous · Accepted solution]

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

My Favorite DAX Feature: SELECTEDVALUE with SWITCH | Winston-Salem Power BI User Group (pbiusergroup...

Regards,

Xiaoxin Sheng