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...
Need Help
  • shuhn1229's avatar
    shuhn1229
    2 years ago
    CALCULATE (
    COUNT( 'Table'[Name] ),
    FILTER ( 
        ALLSELECTED( 'Table' ),
        'Table'[Bucket] <= MAX ( 'Table'[Bucket] )
    ),
    VALUES ( 'Table'[Column1] )
)
shuhn1229's avatar
shuhn1229
Icon for Resolver I rankResolver I
2 years ago
CALCULATE (
    COUNT( 'Table'[Name] ),
    FILTER ( 
        ALLSELECTED( 'Table' ),
        'Table'[Bucket] <= MAX ( 'Table'[Bucket] )
    ),
    VALUES ( 'Table'[Column1] )
)