DAX calculating row total (average) incorrectly

[Anonymous]

I'm not exactly sure why the row total for MC2 is being calculated incorrectly. I created a DAX expression called Induration Delta which calculates the average value for "APC ON" and "APC OFF". I want to find the delta (APC ON - APC OFF) but it should return blank if one of the two don't exist.

Thanks in advance!

[tamerj1]

Hi @Anonymous 

please try

Induration Delta 2 =
AVERAGEX (
SUMMARIZE (
IndurationStates,
IndurationStates[Machine],
IndurationStates[TonsBin]
),
[Induration Delta]
)