Forum Discussion
Cross reference joined tables
I may be making things too simple, but using the same filtering and table setup I was able to get the difference between the sum of [Forecast Amount] and the sum of [Actual Amount] with the following measure (you can change sum to average or max or whatever to suit your needs):
Variance = CALCULATE(SUM(Forecast[Forecast Amount]))-CALCULATE(SUM(Actual[Actual Amount]))
Obviously any slicers/filters/dimensions you use in your report visualizations would need to come from your Project Numbers and Date Dimension tables as your two fact tables don't have any filtering connections.
I may be making things too simple, but using the same filtering and table setup I was able to get the difference between the sum of [Forecast Amount] and the sum of [Actual Amount] with the following measure (you can change sum to average or max or whatever to suit your needs):
Variance = CALCULATE(SUM(Forecast[Forecast Amount]))-CALCULATE(SUM(Actual[Actual Amount]))
Obviously any slicers/filters/dimensions you use in your report visualizations would need to come from your Project Numbers and Date Dimension tables as your two fact tables don't have any filtering connections.
