https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975854#M11788 <P>Hello,</P><P>&nbsp;</P><P>I have a table with coordinates and company name. I need to find coordinates that are the same but have a different company name.&nbsp; Any thoughts?</P><P><img /></P><P class="ics-element-donot-delete 1001_CC@">&nbsp;</P> Mon, 16 Mar 2020 10:30:13 GMT Azejam 2020-03-16T10:30:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975854#M11788 <P>Hello,</P><P>&nbsp;</P><P>I have a table with coordinates and company name. I need to find coordinates that are the same but have a different company name.&nbsp; Any thoughts?</P><P><img /></P><P class="ics-element-donot-delete 1001_CC@">&nbsp;</P> Mon, 16 Mar 2020 10:30:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975854#M11788 Azejam 2020-03-16T10:30:13Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975865#M11789 <P>I would use Power Query and Group By 2 columns (Platuma and Ilguma) and count the values.</P><P>If you can paste as values some data we might "play-along" a bit.</P><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>If you liked my solution please give it a thumbs up </STRONG><STRONG><span class="lia-unicode-emoji" title=":thumbs_up:">👍</span>.&nbsp;</STRONG></P><P><STRONG>If I did answer your question please mark my post as a solution </STRONG><STRONG><span class="lia-unicode-emoji" title=":white_heavy_check_mark:">✅</span>. </STRONG></P><P><STRONG>Thank you !</STRONG></P><P>&nbsp;</P><P>&nbsp;</P><P>Cristian</P><P>&nbsp;</P> Mon, 16 Mar 2020 10:36:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975865#M11789 Cristian_Angyal 2020-03-16T10:36:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975881#M11792 That's a job for Power Query, not for DAX.<BR /><BR />Best<BR />D Mon, 16 Mar 2020 10:52:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975881#M11792 Anonymous 2020-03-16T10:52:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975885#M11793 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="3585" data-lia-user-login="Cristian_Angyal" class="lia-mention lia-mention-user">Cristian_Angyal</a>&nbsp;</P> Mon, 16 Mar 2020 10:57:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identifying-duplicates/m-p/975885#M11793 Azejam 2020-03-16T10:57:35Z