Forum Discussion

Boterkaas45's avatar
Boterkaas45
Frequent Visitor
3 years ago
Solved

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

  • write another measure like this

    SUMX(VALUES('table'[Naam]),[Test])
    • Boterkaas45's avatar
      Boterkaas45
      Frequent Visitor

      Thanks, didn't realise it was this easy.

       

      Have a good one!