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.
How are you getting 3 for Oct 5 I get 2. I want a really good explanation of how the expected results are to be calculated before I try to get the DAX right. Here I am using filters. I have set MODE to Production, and State to Audit and Progress. Only 2 records show up, not 3.
I would prefer you show me using some mockups in excel where you can post a screeshot, not a long paragraph I have to disect and parse, if that is possible. Just be very very clear on how you get 3 for Oct 5 week with the given data.
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.
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.