Various values in line chart (Fx Rate)

[cristianml]

Hi,

I need to show various Measures in a line chart. in this case is depending of the "Location".  Any ideas / measure that could help ?

I think "Var" & "return" could work but not sure how to built that measure.

Thanks & regards

[jdbuchanan71 · Accepted solution]

Hello @cristianml 

I think something like this is what you are looking for.  I don't know where your list of locations is (what table) or what countries you want to use EUR for but this should get you started.

Display Amount =
VAR _Location =
    SELECTEDVALUE ( Locations[Location] )
RETURN
    SWITCH (
        TRUE (),
        _Location = "Argentina", [FX Rate ARS],
        _Location = "China", [FX Rate CNY],
        _Location
            IN {
            "AUSTRIA",
            "BELGIUM",
            "FINLAND",
            "FRANCE",
            "GERMANY",
            "GREECE",
            "ITALY",
            "LATVIA",
            "SPAIN"
            }, [FX Rate EUR],
        _Location = "India", [FX Rate INR],
        _Location = "Poland", [FX Rate PLN]
    )

[cristianml]

hI @jdbuchanan71 

It works perfect !! Thanks!