Forum Discussion

Lotfi96's avatar
Lotfi96
Regular Visitor
2 years ago
Solved

Using Calculate function with special conditions

Hello,   I ran in a bit of an issue while trying to write a measure. Here's an example of currencies. Country Currency USA USD UK GBP   What I'm trying to do is calculate the sum ...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    2 years ago

    Lotfi96 try this:

     

    Sum = 
SUMX ( 
    Data, 
    VAR __Factor = IF ( Data[Current] = "USD", 10, 1000 )
    RETURN
        Data[Sales] / __Factor
)
ChiragGarg2512's avatar
ChiragGarg2512
Solution Sage
2 years ago

Create a measure using if statement,

Sum = if(values(Data[Currency] <> "USD", Calculate(sum(data[sales])/1000), calculate(sum(data[sales])/10))

 

This easure can be wrong but it can give an idea on how to proceed.

 

Or, SWITCH statement can also be used.