I am trying to create a measure to return the difference between two rows where the row data is from a measure. Below are the details of data model. I am looking for a solution that is a measure (or measures) rather than using several calculated columns. Any help is much appreciated.
The model has 2 tables, Table and WeightingsTable (shown below with relationship)
Below is the measure I use to derive value of our data using the weightings