Forum Discussion

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Various values in line chart (Fx Rate)

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

General Comment
Need Help
Show and Tell
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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]
    )

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    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]
    )