Reporting Actuals & Budget via Matrix

DAX DAX Calculations
7

@M_K Using this logic you can make modifications to other measures too:
SampleFile - Copy.pbix (104.3 KB)

image
image1245×723 42.5 KB

Revenue =
VAR CurrentSelection =
    SELECTEDVALUE ( 'GL Summary'[Version_ID], "F02" )
VAR Result =
    CALCULATE (
        [GL Amount],
        KEEPFILTERS ( 'GL Chart'[Level1] = "Revenue" ),
        KEEPFILTERS ( 'GL Summary'[Version_ID] = CurrentSelection )
    ) * -1
RETURN
    Result