Forum Discussion
Boterkaas45
3 years agoFrequent Visitor
Total is not adding up
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
write another measure like this
SUMX(VALUES('table'[Naam]),[Test])
2 Replies
- AhmedxSuper User
write another measure like this
SUMX(VALUES('table'[Naam]),[Test])- Boterkaas45Frequent Visitor
Thanks, didn't realise it was this easy.
Have a good one!