Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
Regards,
Xiaoxin Sheng
great thank you.!
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |