If lookup formula error comparing text with value type

[Anonymous]

Hi Experts

I am getting an error with the following measure =

IF(FACTSalesOrderTable[Ccy]="APP", DIVIDE(FACTSalesOrderTable[discount_amount],LOOKUPVALUE(ExchangeRate[Exchange Rate],ExchangeRate[Currency],FACTSalesOrderTable[Ccy]="APP"),0),""))

Alternatively i could add columns Currency and Ex Rate into FACT Sales and then do the divide based on what the [Ccy] equals

The Exchange Rate Table

IndexCurrencyExchange RateStoreID

1	GBP	1.00	1
2	APP	1.00	5
3	IRE	1.13	6
4	APP IRE	1.75	8
5	AUD	1.13	2
6	EUR	1.13	3
7	USD	1.30	4

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Not very clear. Is this result you want? If not, please add more information.

Measure:

Measure =
DIVIDE(SELECTEDVALUE(FACTSalesOrderTable[discount_amount]),SELECTEDVALUE(ExchangeRate[Exchange Rate]))

Besides, you need to create a relationship between 2 tables. FYI: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Many Thanks Team Tang....Could you kindly have a look this question for 2 days ... please

https://community.powerbi.com/t5/Desktop/TRICKY-Previous-Value/td-p/1844485