https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DateTime-DistinctCount-on-Dates/m-p/2453185#M66105 <P>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.</P><P>&nbsp;</P> Tue, 12 Apr 2022 17:23:23 GMT jamiefisher 2022-04-12T17:23:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DateTime-DistinctCount-on-Dates/m-p/2453185#M66105 <P>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.</P><P>&nbsp;</P> Tue, 12 Apr 2022 17:23:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DateTime-DistinctCount-on-Dates/m-p/2453185#M66105 jamiefisher 2022-04-12T17:23:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DateTime-DistinctCount-on-Dates/m-p/2453610#M66120 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="378142" data-lia-user-login="jamiefisher" class="lia-mention lia-mention-user">jamiefisher</a> , A date column without time, and then you can use that </P> <P>&nbsp;</P> <P>Date = datevalues([Datetime])</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>measures</P> <P>m1= distinctcount(Table[Datetime])</P> <P>&nbsp;</P> <P>m2= distinctcount(Table[Date])</P> Wed, 13 Apr 2022 01:28:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DateTime-DistinctCount-on-Dates/m-p/2453610#M66120 amitchandak 2022-04-13T01:28:32Z