Weekly count is different from individual day count

[shirleyc40]

Hi, I'm having this weird issue again where I do a distinct count for measure and a drill down of dates for dimensions, but the weekly count is different from the count added separately by date. 

I don't have a pic for the individual dates, but I added them twice separately after selecting W32, and got 86 (which is correct). 

The measure formula I use is Count({<PolicyStatus = {'Policy - Accepted'}>} distinct EventNumber)

My data is formatted so that there could be repeating event numbers with the same status and dates. Like I could have two entries with the same eventnumber, status, and date

[jwjackso]

Is it possible that the EventNumber can span multiple days?  If it does and you count distinct, the EventNumber that spans multiple days would only be counted once.

[shirleyc40]

Yes, they can spread over different days. How can I count both?

[asinha1991]

maybe try this

sum(aggr(Count({<PolicyStatus = {'Policy - Accepted'}>} distinct EventNumber),yourdayfield))