calculate a difference in a matrix column

[Anonymous]

I am trying to get a matrix to show the difference  between Current State Total and Future State Total for the below

the data is very simple, but I am trying to avoid transforming the data into many more columns and calculating there.  

Is there any way to do this via the Visualization?

[Icey · Accepted solution]

Hi @Anonymous ,

How about this?

Difference Measure =
CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[ViewpointName] = "Feture State" )
    - CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[ViewpointName] = "Current State" )

And then put it into your Matrix visual.

If this doesn't work, please share me a dummy .pbix file, removing sensitive information.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

you have to create a measure to have different current state and future state

[Anonymous]

Please expand your answer.  The total you see is generated in the Matrix as an average of the values in the 4 previous.  So how would I write a measure to average the current values vs the average of the future values for each row, which is calculated by 8 rows in the table.  below data represent one row