Forum Discussion
calculate a difference in a matrix column
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?
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.
3 Replies
- Icey
Community Support
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
Super User
you have to create a measure to have different current state and future state
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
