Calculate sales measure

scott_bab 

Hi, try with this measure:

Measure =
VAR _District =
    SELECTEDVALUE ( Sales[District] )
VAR _Division =
    SELECTEDVALUE ( Sales[Division] )
VAR _Context =
    SELECTEDVALUE ( Context[Context Name] )
RETURN
    SWITCH (
        _Context;
        "Store"; SUM ( Sales[2018 Sales] );
        "District"; CALCULATE (
            SUM ( Sales[2018 Sales] );
            KEEPFILTERS ( VALUES ( Sales[Department] ) );
            FILTER ( ALL ( 'Sales' ); Sales[District] = _District )
        );
        "Division"; CALCULATE (
            SUM ( Sales[2018 Sales] );
            KEEPFILTERS ( VALUES ( Sales[Department] ) );
            FILTER ( ALL ( 'Sales' ); Sales[Division] = _Division )
        )
    )

If doesn't work replace ; with ,

Maybe need to optimize code but i think will work.

PD. I forgot to tell you

I create a disconnected table with a column named "Context  with this 3 rows : "Store", "District" and Division" and insert it in Columns section in Matrix)

Regards

Victor