cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

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

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I

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

this might help

Measure Totals, The Final Word - Microsoft Power BI Community

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Frequent Visitor

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

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.

2 REPLIES 2
Super User I

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

this might help

Measure Totals, The Final Word - Microsoft Power BI Community

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Frequent Visitor

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

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.

Announcements

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors