Forum Discussion
Filtering Cumulative count by date
Hmm, the file is in my personal dropbox, it wants an email address to share with and I have no address to enter. I can also find no way to share files, apart from photos. Any system I use requires an email to share with, how can I proceed please ?
I've tried typing in the data, a slow process and it won't allow copy/paste, so to provide data it looks like I need to either take a picture and share that or type in the first row and then attach a picture of the remainder. Help !
Thanks again for your time Lin, and if someone can advise how to upload data/files or a way to share I'd be most grateful
Fred
below are snapshots of the data (with the Power BI field definitions) and then the measures I'm using. plus a resulting visual and shot of the data in the "Cumulative" measure entries, all showing 21.
In the earlier shot, showing the chart that was produced, it gives 21 as the result for all the measures, even if there is no data that obeys the filters, I tried adding the additional filter you suggested but it made no difference
v-lili6-msft Here's a shot of what I'd hope to achieve, admittedly the date scale is wrong as I'm looking for a monthly summary, but this was a quick'n'dirty in Excel