Column subtotal calculation

[MarcinZ]

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? 

[v-yalanwu-msft · Accepted solution]

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.

[MarcinZ]

Hi,

Unfortunatelly I can not share my file. 

Do you have any advice how to fix this issue? 

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.