Forum Discussion
Data won't add up
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.
Why don't you use the original date column?
6 Replies
Try this instead:
AWCompleted = COUNTROWS('TableName')
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.Why don't you use the original date column?
