Forum Discussion
Calculated column IF always returns FALSE
I have the following calculated column, and for some reason it will always return to the FALSE expression (i.e. it always uses the RateToDollar): TransactionAmountConverted = CALCULATE(VALUES(Tra...
Would need some sample/example data or for you to share a link to your PBIX file. Context issues are tricky.
Part of my data modelSample data
The original transaction amounts can be in any currency available in the Currency table. Based on the user's choice of report filter (currently either USD or EUR), the Transaction Amount should display the transaction's converted amount. So for example, if the user selects 'EUR' in the report filter, the Transaction Amount column should display all original transaction amounts converted to euros. Similarly, if the user would select dollar, for dollars.
Oh, and the CurrencyFormat was created for the sole reason to act as a report filter.