Forum Discussion

trdoan's avatar
trdoan
Helper III
7 years ago
Solved

DAX to look up shared items using variable

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!

 

 

 

 

 

 

 

 

 

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    trdoan ,

     

    You may try adding measures as follows.

    Measure =
"CHR.FR"

    Measure 2 =
VAR v = [Measure] RETURN v

3 Replies

    • trdoan's avatar
      trdoan
      Helper III
      7 years ago

      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's avatar
        v-chuncz-msft
        Community Support
        7 years ago

        trdoan ,

         

        You may try adding measures as follows.

        Measure =
"CHR.FR"

        Measure 2 =
VAR v = [Measure] RETURN v