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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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