Forum Discussion
Background Color Conditional Format Based on External Rules
The Table on the left is actual aggregated value of sales across different states/Countries. While the table on left is a static table which has forecasted sales for each country/state. I wou...
Tanushree_Kapse Thanks for your comments. I got the gist of the solution. A calculated column and a measure as you suggested should together help solve this.
So this is what i did.
Step 1 : Created a calculated column which is made by
Forecasted Value = LOOKUPVALUE(Reference[Forecast Sales 1],Reference[Country],'Fact'[Country],Reference[State],'Fact'[State])
Step 2: Created a measure called variance as
Variance = SUM('Fact'[Sum Sales]) - AVERAGE('Fact'[Forecasted Value])