DAX formula not giving the expected solution

[Anonymous]

Hi All,

I have attached 2 images below.

They are both in the same table, just different regions. The problem is, for the region EMEA, I need to apply exchange rates.  Hence I have used the formula below:

R+ Order Value = IFERROR(LOOKUPVALUE('R+ Orders'[Material Value in-week],'R+ Orders'[PartPlantbyYearWeekNum],'Part File'[PartPlantbyYearweekNum])/'Part File'[Exchange Rates],BLANK())

There is some problem with the formula because, there is no exchange rate for NA and hence R+ Order value column goes blank. 

I need to correct the formula in a way, where ther exchange rate is applied to EMEA and NA should not have blank values.

How can I correct the formula above?

I am new to powerBI so any help would be appreciated!

Thank you!

[Greg_Deckler · Accepted solution]

@Anonymous Your images are too small to read. Try this:

R+ Order Value = 
  VAR __MaterialValue = LOOKUPVALUE('R+ Orders'[Material Value in-week],'R+ Orders'[PartPlantbyYearWeekNum],'Part File'[PartPlantbyYearweekNum])
  VAR __ExchangeRate = 'Part File'[Exchange Rates]
RETURN
  IF(ISBLANK(__ExchangeRate),__MaterialValue,DIVIDE(__MaterialValue,__ExchangeRate,0))

[Anonymous]

Thanks a lot! @Greg_Deckler