https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identify-Distinct-Values-for-Column-B-based-on-Column-A-s-Values/m-p/1575826#M31444 <P>This post has been removed.&nbsp;</P> Mon, 09 Aug 2021 14:36:05 GMT Anonymous 2021-08-09T14:36:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identify-Distinct-Values-for-Column-B-based-on-Column-A-s-Values/m-p/1575826#M31444 <P>This post has been removed.&nbsp;</P> Mon, 09 Aug 2021 14:36:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identify-Distinct-Values-for-Column-B-based-on-Column-A-s-Values/m-p/1575826#M31444 Anonymous 2021-08-09T14:36:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identify-Distinct-Values-for-Column-B-based-on-Column-A-s-Values/m-p/1575923#M31454 <P>Anonymous</LI-USER> , Try measure like</P> <P>Opportunity done by more than one person =countx(filter(summarize(Table, table[Opportunity ID], "_1", distinctcount(Table[Assigned Name])),[_1] &gt;1),[Opportunity ID])</P> <P>&nbsp;</P> <P>Person count for Opportunity done by more than one person=</P> <P>Sumx(filter(summarize(Table, table[Opportunity ID], "_1", distinctcount(Table[Assigned Name])),[_1] &gt;1),[_1])</P> <P>&nbsp;</P> Thu, 31 Dec 2020 04:21:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Identify-Distinct-Values-for-Column-B-based-on-Column-A-s-Values/m-p/1575923#M31454 amitchandak 2020-12-31T04:21:25Z