hoping someone here can provide help. I have built a custom Power BI report using a matrix format, showing both Forecast and Budget (able to differentiate by filtering on plan type), however I cannot seem to be able to create a new measure to show the variance between the 2. I have tried all sorts of formulas as per instructions from Power Bi forums, latest one I used is below, however it does not work.
Variance =
CALCULATE (
SUM(DWH_FIN_PLAN_SUMMARY_FACTS[PLAN_COST] ),
DWH_FIN_PLAN[FIN_PLAN_TYPE_KEY] = "Budget"
)
- CALCULATE (
SUM(DWH_FIN_PLAN_SUMMARY_FACTS[PLAN_COST] ),
DWH_FIN_PLAN[FIN_PLAN_TYPE_KEY] = "Forecast"
)
Any ideas on how to create this?
Thanks.
Dana