Calculate a value with a dividor depending on a true/false column

[oliharford]

Hi,

I am hoping someone can help!

I have some order data where I need to calculate a profit however depending on payment method this varies. I essentially have a field that I need to get the correct calculation for which is the CostToUser.

This is what I currently have and is essentially what I am trying to do but as a novice I am not sure I know how to get this to actually work: 

TrueCostToUser = SUMX(FactCinemaSocietyOrderItems, IF('FactCinemaSocietyOrderItems'[IsCardPayment]=TRUE(), CALCULATE(SUM('FactCinemaSocietyOrderItems'[CostToUser])), CALCULATE(DIVIDE('FactCinemaSocietyOrderItems'[CostToUser],'FactCinemaSocietyOrderItems'[ExchangeRate]))))

In my head the logic is as simple as:

IF IsCardPayment = True 

  then

    CostToUser

  Else

    CostToUser/ExchangeRate

End If

I hope this is enough information for someone to help.

[oliharford · Accepted solution]

I am not sure why i was overcomplicating it or what went wrong with my original attempts but I have resolved this with a simple new column:

TrueCostToUser = if('FactCinemaSocietyOrderItems'[IsCardPayment]=TRUE(),FactCinemaSocietyOrderItems[CostToUser],DIVIDE(FactCinemaSocietyOrderItems[CostToUser],'FactCinemaSocietyOrderItems'[ExchangeRate]))