Forum Discussion

juangomez's avatar
juangomez
Icon for Helper I rankHelper I
6 years ago

Divide by Constant Currency

Hello   I am trying to optimice the following Dax measure:   SUMX ( FILTER(Complete_DATA,Complete_Data[Version] in VALUES('Scenario 1'[Scenario 1])), DIVIDE ( Totales[Gross S...
currency conversion
DAX Calculation
juangomez's avatar
juangomez
Icon for Helper I rankHelper I
6 years ago

I am doing the following:

 

 

Gross Sales 1 = 
var Sales = 
    CALCULATE(
        Totales[Gross Sales],
        Complete_Data[Version] in VALUES('Scenario 1'[Scenario 1])
        )

var Exchange = 
    CALCULATE(
    [TRM],
        FX[Version] in VALUES(Forex[Currency]),
        USERELATIONSHIP(Complete_Data[Month],FX[Month])
    )

return DIVIDE(Sales,Exchange)

 

 

 

But apparently it is not calculating correclty:

 

 

The right one is the correct calculation with the old & inneficient code. Any suggestions?