Forum Discussion
Conditional Formatting Quirks
OK sure thing,
So the measure I have for variance is as follows:
Forecasted Variance = (Calculate(COUNTROWS(Headcount), Headcount[Current Status] = "Established") + (Calculate(COUNTROWS(Headcount), Headcount[Current Status] = "New Starter")) - SUM(HCBudget[HC Value])
This then generates the difference in absolute terms between the total of Established and New Starter employees minus the value in the budget column.
I then have 2 slicers for the budget year and type (e.g. 2019 provisional) and the specific dates we are looking at.
I then take this variance data and put it in a visual table for the report with the forecast value (which is the first part of the H/C variance essentially) and compare it with the budget figure.
| Forecast | Budget | Variance |
| 180 | 190 | -10 |
It is the latter column on the table in the report (visual table) that I want conditionally formatted and it refuses to do so depsite entering the correct rule set.
