Forum Discussion
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 specif...
trdoan ,
You may try adding measures as follows.
Measure = "CHR.FR"
Measure 2 = VAR v = [Measure] RETURN v
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!
trdoan ,
You may try adding measures as follows.
Measure = "CHR.FR"
Measure 2 = VAR v = [Measure] RETURN v