cancel
Showing results 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])``

Proud to be a Super User!

Announcements