Forum Discussion

LisaB's avatar
LisaB
Helper III
4 years ago
Solved

SELECTEDVALUE and SWITCH doesn't return value

Hi,   I have a table where I want to return exchange rates based on a selected value.   Table LCY is used as a slicer and only single selection is allowed. I have multiple exchange rate tables an...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi LisaB ,

    In your sample, if ā€œExchange Rateā€ is a measure, you can use MAX function to return the current value.

     

     

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

LisaB What does your data model look like? RELATED only works across 1 to many relationships and only returns values from the 1 side of the relationship.

LisaB's avatar
LisaB
Helper III
4 years ago

Hi Greg,

 

This is how it looks like. I tried only RELATED and it returns the correct values for each currency table (pleae disregard the misspelling šŸ™‚).