Filtering columns in stacked column chart

cmilligan262 see the full explanation in the measure

Measure = 
VAR __rows = 
DISTINCT ( --distinct will give us unique list of selected scenarios, it is required because if default scenario is selected in the slicer and we are also adding the default scenario in the UNION section, distinct will get us unique scenarios
    UNION (  --union will add default scenario with all the selected scenarios in the slicer
        CALCULATETABLE ( VALUES ( Slicer[Category] ), ALL ( Slicer[Category] ), Slicer[Default] = "Default" ), --get values for Actuals by looking at default column
        VALUES ( Slicer[Category] ) --get list of all the selected sceanarios in the slicer
    )
)
RETURN
CALCULATE ( 
    SUM ( Data[Amount] ),  --measure on which we want to apply the selected, it could be any existing measure
    KEEPFILTERS ( --keefilters to keep the row contet of the scenario
        TREATAS ( __rows, Data[Category] )   --treatus will be used to filter the scenarios
    ) 
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!