Data won't add up

[Thomas_MedOne]

I've been trying to figure out how to search on this but I am not finding people complaining on this problem. I probably don't know how to properly search for what I'm looking for...

I have a table that is pretty simple..  AWVbyUser

Date	Adsid	other columns...
5/1/2023	123	...
5/1/2023	156	...
5/1/2023	145	...
5/2/2023	123	...
5/2/2023	114	...

I created a measure: AWCompleted = CountA(AWVbyUser[Asid])

When I display the data as a table visual they are not calculating. I get:

Date	Completed
5/1/2023	1
5/1/2023	1
5/1/2023	1
5/2/2023	1
5/2/2023	1

I should be getting like 5/1/2023, 3 and 5/2/2023, 2

I have a calendar visual and when I switch to that, the calendar simply shows a "1" on every day that something was done rather than the total amount.

Originally the Date field was a date/time field with a unique timestamp too but I copied the column and reformatted it to be just date. So, I thought this would be fine.  Is that the problem somehow? It sees date as a unique value?

If I remove Date and add the person's name, it summarizes the data and calculates but adding date it goes back to each individual date.  I don't get it.

[ray_aramburo]

Try this instead:

AWCompleted = COUNTROWS('TableName')

[Thomas_MedOne]

Same Result.  Now there are two date columns. An Admission date column and this date column. Admission date is linked to a date table that is used in slicers on the page.  When I link that to the date colunn here it breaks everything on the page.  But I thought I heard that relationships can mess things up when calculating.

It is as if it's seeing each date field as a unique value when it's not.  I have a similar table and visual that works just fine and I can't seem to figure out why that works and this doesn't.

[ray_aramburo · Accepted solution]

Why don't you use the original date column?

[Thomas_MedOne]

I don't know why it works but using admission date in the date/table puts the data in the right "end date" box and summarizes the data. It doesn't make sense to me but it is working and validated.

[Thomas_MedOne]

The Admission date column? I can try that to see what happens but the report is how many this person "completed" so the "enddate" column is what I need to display.  the Admission date may have been months ago but the procedure was completed this month. 

The original enddate value is a date/time stamp but I only need to know how many per day so I transformed the column to a date-only field.

[Thomas_MedOne]

Putting Admission date in did make it calculate right. So, I guess it has something to do with the relationship?  I added a secondary relationship to the table and I used calculate and "use relationship" for the measure and that resulted in zero values.