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.

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Do you mean a column as in a calculated column in a physical table? If so, it won't work: physical tables are "calculated" when the model is loaded and are oblivious to slicers.

You can however use it as a measure in a table visual

LisaB's avatar
LisaB
Helper III
4 years ago

Hi Paul,

 

I don't really follow. Yes, it is a column but when creating a measure instead I get an error saying following:

 

"The column either doesn't exist or does not have a relationship"