Column totals - revenue calculation based on country

[AdamRobC]

Hi,

I am trying to apply a static currency conversion to a calculated revenue metric for one country, whilst keeping the values the same for all other countries.

The below DAX statement returns the correct revenue values I need:

Net Revenue TEST = IF(SELECTEDVALUE(Country[Country]) = "Ireland",[Net Revenue] / 1.17,[Net Revenue])

However the column total is not correct and is showing the calculated total BEFORE the conversion is applied.

Any advice?

Thanks,

Adam

[parry2k]

@AdamRobC try this

Net Revenue TEST = 

SUMX ( VALUES ( Country[Country] ), 
IF(SELECTEDVALUE(Country[Country]) = "Ireland",[Net Revenue] / 1.17,[Net Revenue])
)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[AdamRobC]

@parry2k thanks for the reply, but the column total is still the same as before 😞

[parry2k]

@AdamRobC [New Revenue] is a column or a measure? How you visualize it? What is your data model look like? Share relationship diagram.

[AdamRobC · Accepted solution]

@parry2k it's a calculated measure.

I managed to get it working by creating new columns in the raw orders table for the adjusted revenue values based on a simple IF statement, and then creating new measures based on those.