topic need code in DAX Commands and Tips

need code

Anonymous — Sat, 15 Feb 2020 00:47:08 GMT

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.

Re: need code

Anonymous — Sat, 15 Feb 2020 00:48:35 GMT

When select R1 need the below desired output

Re: need code

Anonymous — Mon, 17 Feb 2020 08:02:10 GMT

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.

Re: need code

Anonymous — Tue, 18 Feb 2020 00:46:43 GMT

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

Re: need code

Anonymous — Tue, 18 Feb 2020 00:48:42 GMT

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