Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple values are supplied where a single value was expected - If Statement

Hi All,   I am stuck on a verge of closure, please help.   I have a table where i have create 2 column one financials in Euros and another one Financials in Dollar. I need to display the values ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    You are trying to create a column with a slicer value. Only  a measure can use  Slicer Value. 

     

    new mesure =

    if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

hi Anonymous 

try SELECTEDVALUE():

= if(selectedvalue([selected currency]) = "eur", [Result], [Result2])