HELP: Compare 2 columns on same visual where relationship is many to many

[Anonymous]

I want to compare 2 columns on same visual at a row by row level, if the name matches I want to either only show the columns that match, or at least mark them with a "yes" in a new column:

The relationship between both tables is Many to Many. I AM LOOKING FOR A SOLUTION WHICH DOESNT CHANGE THIS.

Basically in the below Visual, the columns of Sales person and User who did activity come from different tables with Many to Many relationship. All I want is that if Sales person says the same thing as User who did activity, then to mark it as "yes", or that the visual would only show those that match. (Expected result: row 1, 4, 7, 9 marked as "Yes" to match)

In excel I would simply add a new column and use =if(Sales person = User who did activity,"Yes", "No") ...but powerbi wont allow this because of the many to many relationship....and wont allow to use related function either.

Row	Sales Person	Sales Persons Customers	User who did activity
1	A	Customer 1	A
2	A	Customer 1	B
3	A	Customer 1	C
4	A	Customer 2	A
5	A	Customer 2	B
6	B	Customer 1	A
7	B	Customer 1	B
8	B	Customer 2	A
9	B	Customer 2	B

There has to be a "dumb" way to do this without going into the relationships!

[amitchandak]

@Anonymous , is your issue resolved?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Refer to the measure below.

Measure = 
var a = SELECTEDVALUE('Table 1'[Sales Person])
var b = SELECTEDVALUE('Table 2'[User who did activity])
return
IF(a=b&&NOT(ISBLANK(a))&&NOT(ISBLANK(b)),"yes",BLANK())

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Anonymous ,

can you provide sample data for the two tables?