Forum Discussion
Smart IF
Hi, I'm looking for a smart way, using a measure, to assign a discount value against a customer. I have 2 tables Transactions and DiscountCriteria. I would like to SUM the Tons for each Compa...
NipponSahore, I'm pretty sure that formula only applies to a calculated column, not a measure.
NipponSahore, I used a 2nd measure similar to this:
Measure = IF(HASONEVALUE(SAGE_Extract[Symbol]),IF(VALUES(SAGE_Extract[Symbol]) = "USD",[Discount - Volume]*'Exchange Rate'[Exchange Rate Value],[Discount - Volume]))
I might re-visit this in the future to see if I can combine the 2 measures into 1, but I am happy for now.