Forum Discussion
Rolling cumulative Count
- 5 years ago
Ok Anonymous - see if this works. It returns the data on the right side of the image. It is not affected by the slicers, just showing that it returns the same results.
Running Total = COUNTX( FILTER( 'Table', 'Table'[Mode] = "Production" && ('Table'[State] = "Progress" || 'Table'[State] = "Audit") ), 'Table'[Item] )Note: you must have a date table. Grab the PBIX file I linked to above in my first post. It is updated with this new data and the measure.
- Anonymous5 years ago
Sorry for the delay, restriction at my end. Thanks for the help it worked well.
My bad, yes you are right while I am applying filter I counted previous week record as well.
Ok Anonymous - see if this works. It returns the data on the right side of the image. It is not affected by the slicers, just showing that it returns the same results.
Running Total =
COUNTX(
FILTER(
'Table',
'Table'[Mode] = "Production"
&& ('Table'[State] = "Progress" || 'Table'[State] = "Audit")
),
'Table'[Item]
)
Note: you must have a date table. Grab the PBIX file I linked to above in my first post. It is updated with this new data and the measure.