Forum Discussion

shuhn1229's avatar
shuhn1229
Icon for Resolver I rankResolver I
2 years ago
Solved

help with a cumulative total visual

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!

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

1 Reply

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