DateTime -DistinctCount on Dates

[jamiefisher]

I have a table with datetime field, I want to add a new measure to show totals per date in a visual and from this I also want a disctinct count on the dates in the table. Help appreciated.

[amitchandak]

@jamiefisher , A date column without time, and then you can use that

Date = datevalues([Datetime])

measures

m1= distinctcount(Table[Datetime])

m2= distinctcount(Table[Date])