Forum Discussion
shuhn1229
Resolver I
2 years agohelp 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
- shuhn1229
Resolver I
CALCULATE ( COUNT( 'Table'[Name] ), FILTER ( ALLSELECTED( 'Table' ), 'Table'[Bucket] <= MAX ( 'Table'[Bucket] ) ), VALUES ( 'Table'[Column1] ) )