need code

Question

Hello Everyone,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; I have the "constant variable" as the main group in my table and then I have subgroups&nbsp;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.&nbsp;&nbsp;&nbsp;

anonymous · Answer

&nbsp;&nbsp;When select R1 need the below desired output&nbsp;&nbsp;&nbsp;

anonymous · Answer

WHat do you mean by constant variable?&nbsp;DO you want to display only representative who are present in more than one group ?&nbsp;For groupCustomer with more than 1 group=Calculate(DistinctCount(Table[Group]),Allexcept(table[Customer])&nbsp;Customer with more than 1 Subgroup=Calculate(DistinctCount(Table[SubGroup]),Allexcept(table[Customer])&nbsp;And add this measure to visual level filter and set "IS greater than 1".&nbsp;Thanks &amp; regards,Pravin Wattamwarwww.linkedin.com/in/pravin-p-wattamwarIf I resolve your problem Mark it as a solution and give kudos.

anonymous · Answer

Data set&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Client listRetailer listSales Representative&nbsp;&nbsp;&nbsp;AaR1&nbsp;When select R1 on the slicer&nbsp;BaR2&nbsp;Output requiredCbR1&nbsp;Client listRetailer listOverlapping efforts of Sales RepresentativeRetailer namesDgR7&nbsp;AaR2 on&nbsp;aEdR1&nbsp;CbR5 on&nbsp;d and rFdR5&nbsp;EdR7 on&nbsp;q,b, and gGbR1&nbsp;Gb&nbsp;&nbsp;HbR7&nbsp;I&nbsp;f&nbsp;&nbsp;I&nbsp;fR1&nbsp;KE&nbsp;&nbsp;JrR5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KER1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LqR7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

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

Forum Discussion

need code

4 Replies

Related content

Missing Codes

User Group Leader Code of Conduct

DAX code issue

Error Code: 9518

Dax code optimization

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