Calculate SUM in matrix not showing correct values

[paragchapre1]

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.

FTE calculate PBIX 

[V-pazhen-msft · Accepted solution]

@paragchapre1 

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.

[amitchandak]

@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])