topic Re: Distinct CountRows based on Date and Location in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-CountRows-based-on-Date-and-Location/m-p/2690602#M80997 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="328492" data-lia-user-login="adoster" class="lia-mention lia-mention-user">adoster</a> , Try measure like </P> <P>&nbsp;</P> <P>countrows(summarize(Table, table[Username], Table[Location], Table[date]) )</P> Tue, 09 Aug 2022 16:32:42 GMT amitchandak 2022-08-09T16:32:42Z Distinct CountRows based on Date and Location https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-CountRows-based-on-Date-and-Location/m-p/2690520#M80990 <P>Trying to CountRows except when User is in the same location on the same day.</P><P>In example below Mickey Mouse would be counted 3 times because Row 3 is on the same day and same location.</P><P>&nbsp;</P><P>Example Table:</P><TABLE><TBODY><TR><TD>User Name</TD><TD>Location</TD><TD>Date</TD><TD>Color</TD></TR><TR><TD>Mickey Mouse</TD><TD>A</TD><TD>7/1/2022</TD><TD>Red</TD></TR><TR><TD>Mickey Mouse</TD><TD>B</TD><TD>7/1/2022</TD><TD>Red</TD></TR><TR><TD>Mickey Mouse</TD><TD>A</TD><TD>7/1/2022</TD><TD>Blue</TD></TR><TR><TD>Mickey Mouse</TD><TD>A</TD><TD>7/2/2022</TD><TD>Red</TD></TR><TR><TD>Donald Duck</TD><TD>C</TD><TD>7/1/2022</TD><TD>Red</TD></TR></TBODY></TABLE> Tue, 09 Aug 2022 15:55:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-CountRows-based-on-Date-and-Location/m-p/2690520#M80990 adoster 2022-08-09T15:55:22Z Re: Distinct CountRows based on Date and Location https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-CountRows-based-on-Date-and-Location/m-p/2690602#M80997 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="328492" data-lia-user-login="adoster" class="lia-mention lia-mention-user">adoster</a> , Try measure like </P> <P>&nbsp;</P> <P>countrows(summarize(Table, table[Username], Table[Location], Table[date]) )</P> Tue, 09 Aug 2022 16:32:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinct-CountRows-based-on-Date-and-Location/m-p/2690602#M80997 amitchandak 2022-08-09T16:32:42Z