Inconsistency in data type in Totals row

[Anonymous]

Looking for a way to solve this problem I'm facing here, I have this table to compare between two measures, OEE and Declared. However, the totals row are inconsistent in the way that, the OEE totals column shows up as the average of the values shown, while Declared and Difference columns show up as the sum of the values shown. Looking for an explanation for this phenomenon, and hopefully a way to resolve this. I would want all of them to show up as sums. Please check the attached image for the table I have at the moment. Please do ask if you need more information from me.

Thanks in advance.

[v-kelly-msft]

Hi  @Anonymous ,

Have you checked the suggestion by @amitchandak ?Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak · Accepted solution]

@__jz__ , this happens because of the row context. if you create a formula that uses the row context

Try it as

OEE M hours at sumx(Values(Table[Line]),[OEE Hours])
Declared M hours asmx(Values(Table[Line]),[Declared hours])

diff [OEE M Hours] -[Declared Hours M]

Total reference problem :https://www.youtube.com/watch?v=Ka7Ds4EAjNQ

[Anonymous]

It works, thanks a bunch. Marked as solution.