Sum of rows not working

[F0RCE]

Hello,

I made a report based on Microsoft Forms data - I wanted it to show cummulative forms entries in regards to date.

As a value I set ID (it starts from 2 and end on 183). It was set as MAX in report.

And as axis I used date of start and date of end.

It looks great to be honest, but it shows 183 entries, but there are only 182 entries (remember it starts from 2).

As I workaround I could filter it to shows values on up to 182, but then tooltip drilldown report won't show accurate data.

Do you perhaps know how can I show this data correctly? Probably MAX is not a good way, but any other setup makes data not cummulative in regards to date.

Maybe transform ID to show all ID minus 1 (I don't use them anywhere else, they are just counters for me)

[v-easonf-msft]

Hi,  @F0RCE 

Could you please tell me whether your problem has been solved?

For now, there is no content of description in the thread. If you still need help, please share a sample file for further research.

Best Regards,
Community Support Team _ Eason

[VahidDM]

Hi @F0RCE 

Try to use this measure to find the cumulative count:

Measure=

CALCULATE(COUNT('Table'[ID],filter(all(table),'Table'[Date]<=max('Table'[Date]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!