Forum Discussion
Column subtotal calculation
Hi,
I would like to change the way the subtotal in MAD April coulmn is calculated. All rows in MAD April column are calculated correct because it should be Absolute value from Sales-forecast April column. The total for this column is ot correct because it should be SUM of all rows, not absolute value of total from Sales-forecast April column.
Is there any way to change the calculation way for subtotal row?
Hi, MarcinZ ;
You could use INISCOPE(),such as:
Measure = IF(ISINSCOPE('financials'[Country]),IF(ISINSCOPE('financials'[Product]),-[sales1],2),0)You can change the values according to your own files，if don't success, you could Create a simple example with no sensitive information and similar to your table, and share the results you want to output.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi,
Share the link from where i can download your PBI file.
Hi,
Unfortunatelly I can not share my file.
Do you have any advice how to fix this issue?
Hi, MarcinZ ;
You could use INISCOPE(),such as:
Measure = IF(ISINSCOPE('financials'[Country]),IF(ISINSCOPE('financials'[Product]),-[sales1],2),0)You can change the values according to your own files，if don't success, you could Create a simple example with no sensitive information and similar to your table, and share the results you want to output.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
