Forum Discussion
Identify Distinct Values for Column B based on Column A's Values
This post has been removed.
Anonymous , Try measure like
Opportunity done by more than one person =countx(filter(summarize(Table, table[Opportunity ID], "_1", distinctcount(Table[Assigned Name])),[_1] >1),[Opportunity ID])
Person count for Opportunity done by more than one person=
Sumx(filter(summarize(Table, table[Opportunity ID], "_1", distinctcount(Table[Assigned Name])),[_1] >1),[_1])
1 Reply
Anonymous , Try measure like
Opportunity done by more than one person =countx(filter(summarize(Table, table[Opportunity ID], "_1", distinctcount(Table[Assigned Name])),[_1] >1),[Opportunity ID])
Person count for Opportunity done by more than one person=
Sumx(filter(summarize(Table, table[Opportunity ID], "_1", distinctcount(Table[Assigned Name])),[_1] >1),[_1])