DAX : Sum of parts is same as sum of total parts

[medaxing]

Hello Guys,

I have created a measure variable debtor_value  and a measure which uses the variable.

The totals works fine for each group but when i select parts the sum is still the total sum. Below is the screenshot and the code.

Any help is really appreciated.

[Anonymous · Accepted solution]

this might help

Measure Totals, The Final Word - Microsoft Power BI Community

[Anonymous · Accepted solution]

this might help

Measure Totals, The Final Word - Microsoft Power BI Community

[medaxing · Accepted solution]

Thank you.

Right, I did try that. But I get blank value: 

var __table = SUMMARIZE('Aging Group', 'Aging Group'[Aging Group], "__value", [AmountbyDDate])
RETURN
IF(HASONEVALUE('Aging Group'[Aging Group]),[AmountbyDDate], SUMX(__table,[__value]))

can't figure it out. any help is really appreciated.

Thanks in advance.