Forum Discussion

larryc's avatar
larryc
New Member
8 years ago

Measure causing sum not to work.

Hello,   Here is the report I am working on: DOWNLOAD     Problem:  When the report date changes, I must be able to supply the correct exchange rate as of that selected report date. This forces ...
Need Help
lcasey's avatar
lcasey
Post Prodigy
8 years ago

Vvelarde,

 

In all my reading, you MUST use HasOneValue . There is simply no other option and there are no other calculations that can lookup a value in another table based on the report date without using HasoneValue.

 

Every single instance I have reviewed on the internet requires HASONEVALUE

 

I beleive I have just stumped the entire DAX community!   This is certainly a BUG!!!!!

 

 

lcasey's avatar
lcasey
Post Prodigy
8 years ago

If I use this formula: 

 

Xrate = IF(MAX('00-Bad_ Debt_Invoices'[CURNCYID]) = "USD",1, LOOKUPVALUE('00-Bad_Debt_MC'[XCHGRATE],'00-Bad_Debt_MC'[CURNCYID],Max('00-Bad_ Debt_Invoices'[CURNCYID]),'00-Bad_Debt_MC'[EXCHDATE],MAX('Calendar'[Date])))

 

then the totals are completely wrong.

 

I HATE DAX!!!!!