Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

need code

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.

 

 

 

4 REPLIES 4
Anonymous
Not applicable

 

 

When select R1 need the below desired output

2-14-2020 4-29-50 PM.png

 

 

 

Anonymous
Not applicable

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
Not applicable

Data set      
Client listRetailer listSales Representative   
AaR1 When select R1 on the slicer 
BaR2 Output required
CbR1 Client listRetailer listOverlapping efforts of Sales RepresentativeRetailer names
DgR7 AaR2 on a
EdR1 CbR5 on d and r
FdR5 EdR7 on q,b, and g
GbR1 Gb  
HbR7 f  
fR1 KE  
JrR5     
KER1     
LqR7     
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors