Forum Discussion
Inconsistency in data type in Totals row
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 ...
@__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
amitchandak
Super User
Super User@__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
It works, thanks a bunch. Marked as solution.