Forum Discussion
Rolling cumulative Count
I am trying to calculate rolling cumulative count by weekstart (from monday) having a context filter but results are not as expected, please help how to work with DAX to get accurate result. Below it...
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.
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.