DAX to look up shared items using variable

[trdoan]

Hi everyone,

Here is my sample file. 

This file is used to compare Vendor CHR.FR against Vendor PWC.CR on only their shared Material Numbers, however, everywhere in this file, I had to specifically point out the names of the 2 Vendors which is not very optimal and quite time-consuming if let's say I'd like to compare another pair. 

Is there a more flexible way to go about this task without so much as changing the names manually every single time? Like using variable?

Thank you so much!

[parry2k]

@trdoan is this what you are looking for?

[trdoan]

Hi @parry2k , thanks for your reply, however, I noticed I asked the wrong question and the sample data didn't quite replicate my real data. I've changed my question and adjusted the link to a very-similar-to-my-real-data file. Apologise for this inconvenience! 

[v-chuncz-msft · Accepted solution]

@trdoan ,

You may try adding measures as follows.

Measure =
"CHR.FR"

Measure 2 =
VAR v = [Measure] RETURN v