plot median value for selected category

I'm trying to plot the median value of counts for 'SC' category based on selection of 'deposit balance group' category on a bar chart. I created a measure using DAX which can calculate the median values. But it looks like my DAX formula is wrong and it's calculating the median for the entire table and not per category.

For Eg, The median value for $100K-$150K group for 'CD' category should be 36, but its showing 270 on the bar chart.

My sample data:

The DAX measure I created:

Measure = 
MEDIANX (
    SUMMARIZE (
        Sheet1,
        Sheet1[SC],
        "Total Count", SUM ( Sheet1[count] )
    ),
    [Total Count]
)

Please let me know how can I overcome this situation.

Thanks

I've attached the pbix file which has the complete data and measure formula: pbix file