Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |