Forum Discussion

jdun's avatar
jdun
New Member
4 years ago
Solved

Adding Absolute Value

Hi PBI Community,     I am trying to come up with a function, expression, or method to display the total of the absolute value column in the below matrix. Var S - F is the variance between forecast ...
  • DataInsights's avatar
    4 years ago

    jdun,

     

    You can try a totals measure like this:

     

    Ab Val Var Totals =
    SUMX ( VALUES ( Items[Item] ), [Ab Val Var] )