Sum Rows With Multiple Duplicate Date Values?

[pe2950]

I'm trying to calculate a YTD value. Each row in my model should be counted as 1, and multiple rows may have the same timestamp. So for a given period i want to count all of the rows during that period. 

My data model has columns [ID], [Timestamp], and i created a numeric column called [count] with a value = 1. I then created a date table and create the relationship between the two on the timestamp column. The relationship is a 1[Date]:*[Timestamp]

My DAX looks like this:

SumOfCount = SUM(tableA[Count])

YTDSumOfCount = TOTALYTD([SumOfCount], DateConsult[Date])

Here is the output i get in a table, and below is the relationship -- I think my Date relationship is broken, but i'm not sure why

[MattAllington]

There are rules for date tables if you want inbuilt time intelligence to work. Have you followed these rules?  

https://exceleratorbi.com.au/power-pivot-calendar-tables/

Also is the data in your data table (timestamp) at the day level (i.e. No timestamp)?  

Alos note you dont need the count column. Just use countrows(tablename)