cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II

## SUMX total not "adding up"

Hi, I am confused about the result of a DAX formula that is giving an unexpected result.

Notice how the totals for the 2 columns don't add up? This is a filtered table.

Total care mins = sum(Table1[Scores])
Test = CALCULATE(sumx(values(Table1[PatientName]),max(Table1[Scores])))

The ACTUAL values from the data are:
 Scores 129 99 246 213 243

I just cannot get my head around why these 2 totals are different. If I remove all the filters, they are still different so I don't think this is the reason.

What am I missing?

Thanks
1 ACCEPTED SOLUTION
Resolver IV

In the total there is no filter on patient. Sumx is iterating over all 5 patients. While iterating it evaluates the second argument (MAX). Because there is no filter context it will evaluate every time the max of all patients (246). In the last step it will aggrate the five 246 in an sum (1260).

2 REPLIES 2
Helper II

Thank you JW_van_Holst! I now get where this number comes from. That makes sense to me.

Resolver IV

In the total there is no filter on patient. Sumx is iterating over all 5 patients. While iterating it evaluates the second argument (MAX). Because there is no filter context it will evaluate every time the max of all patients (246). In the last step it will aggrate the five 246 in an sum (1260).

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors