Matrix subtotals not working with a measure

[monika_eliza]

Hello,

I am trying to build a matrix visualization, however the subtotals are not working properly. I created this measure:

Volume =

    var delta =  CALCULATE(SUM(Append1[Vol]), Append1[Customer_Name1] = "Adjustment") - CALCULATE(SUM(Append1[Vol]), Append1[Customer_Name1] <> "Adjustment")

   var volS = SUM(Append1[Vol])

    return

        IF(CONTAINS(Append1, Append1[Customer_Name1], " Adjustment"), delta, volS)

What I am trying to do is to create an "Adjustment" row (shown as a customer like A,B, C and Other on the screenshot) which will show the difference between "Adjustment" and the sum of the other rows. There are two cases: (1) the country has an "Adjustment" as a row - the subtotal is showing me exactly "Adjustment" value which is not correct, (2) the country do not have "Adjustment" as a row - the subtotals are working then.

I would be very grateful for any tips on this case.

[Greg_Deckler]

@monika_eliza First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Also: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community

[monika_eliza]

Thank you @Greg_Deckler for your reply. I created the measure 

m_Total 1 =

VAR _table = SUMMARIZE('Append1', Append1[Customer_Name1], "_value", [Volume])

return

IF(HASONEVALUE(Append1[Customer_Name1]), [Volume], SUMX(_table, [_value]))

It is indeed working for totals, but the subtotals are still not right. Do you know what might be causing this problem?