Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
When select R1 need the below desired output
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.
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 |
I just want to display more than one representative working with the same retailer in the list and display that information with client details.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |