lookup value based on measure

Hi Lydia,

Thanks for the reply and unfortunately solution you provided is not working. here are more details. 

Here is one of the measure which I'm using to get factor from a non relation table and it is working fine

Factor = 
var myTotalPoints = [Total Points]

return
CALCULATE
(
	VALUES('Score Point'[Factor]), 
	FILTER
	('Score Point', 
		'Score Point'[Measure] = "Factor" &&
		myTotalPoints >= 'Score Point'[Start Range] && 
		myTotalPoints <= 'Score Point'[End Range]
	)
)

here is the screen shot of "Factor" measure from above DAX

Now based on this "Factor" measure I want to create a calculated column to get value from another non-related table, reason I need calculated column, becuase I want to categorize it as a "image url" to show the image for each "Factor". 

So I added new calculated column called "Image" with following DAX and getting same value for each "Factor", here is dax for "image 1" column

image 1 = 
CALCULATE(FIRSTNONBLANK(Images[Image 1],""),FILTER(Images,Images[Factor]=[Factor]))

and I tried the same with measure and it worked but I cannot change the category for a measure

here is DAX for measure 

measure = if( [Factor] = BLANK(), "Blank", LOOKUPVALUE(Images[Image 1],Images[Factor],[Factor]))

now if you see the result for "image 1" which si calculated column and "measure" which is a measure, for "image 1" i'm getting the same value but for "measure" i'm getting correct value, screen shot  below