Forum Discussion

zself's avatar
zself
Regular Visitor
4 years ago

Calculating difference per row with initial row filter

I don't know how to ask this question properly, but here's my quick measure and a screen shot showing what I want. Investment % difference from 2019 = IF( NOT ISBLANK(SUM('tbl_ConsolidatedYears'[...
zself's avatar
zself
Regular Visitor
4 years ago

I think I pasted wrong code. Here's my most recent attempt at the measure:

Investment A difference from 2019 =
VAR __BASELINE_VALUE =
    CALCULATE(
        SUM('tbl_ConsolidatedYears'[Investment A]),
        'tbl_ConsolidatedYears'[Transaction Year] IN { "2019" }
    )
VAR __MEASURE_VALUE = SUM('tbl_ConsolidatedYears'[Investment A])
RETURN
    IF(NOT ISBLANK(__MEASURE_VALUE), __MEASURE_VALUE - __BASELINE_VALUE)