help with a cumulative total visual

[shuhn1229]

hi all,

I have a visual that sort of looks like the below

I developed a measure for this and placed in in the y axis 

CALCULATE (
    COUNT( 'Table'[Name] ),
    FILTER ( 
        ALL ( 'Table' ),
        'Table'[Bucket] <= MAX ( 'Table'[Bucket] )
    ),
    VALUES ( 'Table'[Column1] )
)

The measure works appropriately when I have a slicer populated with a value from Column 1 selected. However, I get nonsense results when I add a slicer for Column 3 and try to slice by that metric. I should add, for every distinct value of Column 1 there tends to be just value of Column 3. But Column 3 can contain many values of Column 1.

Thanks!

[shuhn1229 · Accepted solution]

CALCULATE (
    COUNT( 'Table'[Name] ),
    FILTER ( 
        ALLSELECTED( 'Table' ),
        'Table'[Bucket] <= MAX ( 'Table'[Bucket] )
    ),
    VALUES ( 'Table'[Column1] )
)