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

amitchandak's avatar
amitchandak
Super User
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]))