need code

[Anonymous]

Hello Everyone,

          I have the "constant variable" as the main group in my table and then I have subgroups in my data set and each subgroup has multiple representatives to represent it in the market. I need to find out which representative is involved in more than 1 group and need to display those groups with the main group details and other details in the table.

[Anonymous]

When select R1 need the below desired output

[Anonymous]

WHat do you mean by constant variable?

DO you want to display only representative who are present in more than one group ?

For group

Customer with more than 1 group=Calculate(DistinctCount(Table[Group]),Allexcept(table[Customer])

Customer with more than 1 Subgroup=Calculate(DistinctCount(Table[SubGroup]),Allexcept(table[Customer])

And add this measure to visual level filter and set "IS greater than 1".

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Data set
Client list	Retailer list	Sales Representative
A	a	R1		When select R1 on the slicer
B	a	R2		Output required
C	b	R1		Client list	Retailer list	Overlapping efforts of Sales Representative	Retailer names
D	g	R7		A	a	R2 on	a
E	d	R1		C	b	R5 on	d and r
F	d	R5		E	d	R7 on	q,b, and g
G	b	R1		G	b
H	b	R7		I	f
I	f	R1		K	E
J	r	R5
K	E	R1
L	q	R7

[Anonymous]

I just want to display more than one representative working with the same retailer in the list and display that information with client details.