My expression for convert IDR amount to SGD return null

[admin11]

Hi All

I have below expression , dont know why it unable to work , as it display null  :-

AMT_ON_HAND_SGD_ = Divide(SUMX(INVC, INVC[UNIT_COST]*INVC[QTY_On Hand]), 'RATE'[_rate])

My PBI file :-

https://www.dropbox.com/s/m4h2ry75jh4n6bn/PBT_V2021_382%20TI_SI_GL%20SAMPLE%20how%20to%20get%20inven...

Paul

[PhilipTreacy · Accepted solution]

@admin11 

Hi Paul,

Download PBIX

I'm not sure what you're expected result is but it looks to me like the [_rate] is measure is wrong because it's getting the RATE from the AR table when I think you shoudl be getting it from the Rate table.

I've amended the measure to this

_rate = SUMX(FILTER('RATE',[SOURCE]=SELECTEDVALUE('RATE'[SOURCE])),[RATE])

Regards

Phil

[admin11]

@PhilipTreacy 

Thank you very much.