Forum Discussion

EMSSS22's avatar
EMSSS22
Icon for Helper I rankHelper I
3 years ago

Writing a measure to subtract two columns same table with filters

Hi    I have 2 columns that i would like to subtract from one another after applied filters.   Eg.   Column B (with version type x and month number x) - Column A (with version type x and month ...
"DAX"
FILTERS DAX KEEPFILTERS
Subtract
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try something like

ForecastCMVariance =
CALCULATE (
    SUMX (
        FilteredCommercial,
        FilteredCommercial[Forecast] - FilteredCommercial[Capital Rental]
    ),
    FilteredCommercial[Version] = "x",
    FilteredCommercial[month number] = y
)