Matrix totals not summing correctly, guessing it has to do with my measure

[analyst312]

I have a matrix when the total is not totaling correctly for on of the columns, which is a measure. 

The Model FTE is the measure and one that is not totalling correctly. 

Here is the script for it: 

Model FTE = IF(
        HASONEVALUE('Job Lookup'[Job Title]),
        [Model FTE CALC],
        SUMX(
            VALUES('Job Lookup'[Job Title]),
            [Model FTE CALC]))

Model FTE CALC = ROUNDUP(DIVIDE(
    SUM(Census_Table[Census]),
    AVERAGE('Job Lookup'[Staffing Target (Regular Clinic)])),0)

Looks like it just isnt rounding up properly, but ive seen other posts about measure not totaling up correctly, so didnt know if it was this. 

[v-xuding-msft · Accepted solution]

Hi @analyst312 ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @analyst312 ,

You need to use a SUMX function to calculate the total values of measure "Model FTE". Because the "Model FTE" calculates values using IF function based on different conditions. The total values will be calculated for the entire context. They don't be grouped together. 

Please try the formula like below.

Measure = SUMX('Table',[Model FTE])

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.