Total is not adding up

[Boterkaas45]

Hello,

I'm trying to get this measure to work. It works fine on an individual level, but the total of the matrix is incorrect. I hope someone can spot my mistake.

Employees who work on a contract basis do not clock in, but for analysis purposes, I want to include their hours. I'm trying to fill it in this way.

It works to some extent, but not at the total level.

I hope someone can spot my mistake.

Thank you in advance!

Boterkaas

[Ahmedx · Accepted solution]

write another measure like this

SUMX(VALUES('table'[Naam]),[Test])

[Boterkaas45]

Thanks, didn't realise it was this easy.

Have a good one!