Issue with totals in a Matrix

Hi,

I am having an issue with totals, and I know I need to do a virtual table to sort it out but I am stuck!

So I have a measure:

Measure 3 =

Var _TT=Calculate(

     MAX('Table'[P70])

     ,USERRELATIONSHIP('Table2'[DD],'Table'[DD])

     ,USERRELATIONSHIP('Table3'[LM],'Table'[LM])

    ,USERRELATIONSHIP('Table4'[Project],'Table'[Project])

    )

Return

SUMX('Table',_TT)

So I have a matrix with the 3 x categories [DD], [LM], [Project] and dates as the columns

I get the correct figures at the lowest levels, but not higher up.

I can see the sub totals are giving me the Max vale for the lower categories

How do I sort it out please!!!