Excluding outside filter context

Hi Anonymous ,

Try to create four measures.

Measure = 
CALCULATE(
    SUM(Sheet1[VALUE]),
    FILTER(
        Sheet2,
        Sheet2[HEIRARCHY] = SELECTEDVALUE(Sheet2[HEIRARCHY]) && Sheet2[HEIRARCHY] <> "Volume"
    ),
    FILTER(
        Sheet1,
    Sheet1[MONTH] = SELECTEDVALUE(Sheet1[MONTH])
    )
)

Measure 2 = 
VAR x = 
CALCULATE(
    SUM(Sheet1[VALUE]),
    FILTER(
        Sheet2,
        Sheet2[HEIRARCHY] = SELECTEDVALUE(Sheet2[HEIRARCHY]) && Sheet2[HEIRARCHY]  =  "Volume"
    ),
    FILTER(
        Sheet1,
        Sheet1[MONTH]= SELECTEDVALUE(Sheet1[MONTH])
    )
)
RETURN
x

Measure 3 = 
VAR x = 
SUMX(
    FILTER(
        ALL(Sheet1),
        Sheet1[MONTH] = SELECTEDVALUE(Sheet1[MONTH])
    ),
    [Measure 2]
)
RETURN
x

Measure 4 = 
DIVIDE(
    [Measure], [Measure 3],
    BLANK()
)

(Note: Do not combine Measure2 and Measure3 into one formula, as this may cause problems.)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.