Forum Discussion
Rolling cumulative Count
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.
Sorry for the delay, restriction at my end. Thanks for the help it worked 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.
I was restricted to copy the workbook, can please share screen captures so I can refer. I was able to create date table.
What do you mean you are restricted? I just checked. It opens fine. You should see this - just click download. It is a PBIX Power BI file, not a workbook.
Sorry for the delay, restriction at my end. Thanks for the help it worked well.