Sum of totals

[ZoltanT]

Hi

I am having trouble with the total value of a measure being calculated. I can see it is multiplying my units and labour as per my code, but I need the final value to be the sum of the total. How do get the measure to calculate the sum of the values in the column? my code is also below. 

Total Labour = SUMX('Table',Table[Total Labour per Activity]*COUNTAX('Table','Table'[Units]))

[mahoneypat · Accepted solution]

Please try this expression.  It should give you the same values on the rows, but also the right "total".

New Measure = SUMX(VALUES(Table[Cityworks Task]), [Total Labour])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[ZoltanT]

Thanks, that has given me a new value i can use elsewhere. Is there any way to display this in the table or is it just best to hide the totals in the table and display the new measure elsewhere?

Thanks again