cancel
Showing results for
Search instead for
Did you mean:
Helper I

## Calculate SUM in matrix not showing correct values

Hello,

I am trying to calculate the sum of numbers in Matrix but it is not showing correct values.

When I select department values then It is showing wrong values.

Below is my PBIX file. I want to calculate the SUM of FTE values as per department.

1 ACCEPTED SOLUTION
Community Support

If you want the sum of FTE in the total, try replace the maxx to sumx.

Total FTE = if(HASONEVALUE(Sickness[PersonnelNumber]),SUM(Sickness[FTE]),SUMX(SUMMARIZE(VALUES(Sickness[PersonnelNumber]),Sickness[PersonnelNumber],"ABCD",SUM(Sickness[FTE])),[ABCD]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support

If you want the sum of FTE in the total, try replace the maxx to sumx.

Total FTE = if(HASONEVALUE(Sickness[PersonnelNumber]),SUM(Sickness[FTE]),SUMX(SUMMARIZE(VALUES(Sickness[PersonnelNumber]),Sickness[PersonnelNumber],"ABCD",SUM(Sickness[FTE])),[ABCD]))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Super User IV

@paragchapre1 , Try the measure like

``Total FTE = SUMx(SUMMARIZE(Sickness,Sickness[Department],Sickness[Name],"_1",if(HASONEVALUE(Sickness[PersonnelNumber]),SUM(Sickness[FTE]),MAXX(SUMMARIZE(VALUES(Sickness[PersonnelNumber]),Sickness[PersonnelNumber],"ABCD",SUM(Sickness[FTE])),[ABCD]))),[_1])``

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

## Helpful resources

Announcements

#### Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

#### Check it Out!

Click here to read more about the March 2021 Updates!

#### The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors