Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This post has been removed.
Solved! Go to Solution.
@Mehal1996 , 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])
@Mehal1996 , 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])
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |