-- Synthetic portfolio measures

Revenue Variance :=
[Actual Revenue] - [Budget Revenue]

Revenue Variance % :=
DIVIDE(
    [Revenue Variance],
    [Budget Revenue]
)

Full Year Forecast :=
[YTD Actual Revenue] +
SUMX(
    FILTER(
        ALL('Date'[Month]),
        'Date'[Month Number] > [Latest Actual Month]
    ),
    [Monthly Forecast Revenue]
)

Scenario ROI :=
DIVIDE(
    [Scenario Revenue],
    [Scenario Investment]
)