Forum Discussion

MarcinZ's avatar
MarcinZ
New Member
4 years ago
Solved

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 Apr...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.