IF/Swtich with Measure - A table of multiple values was supplied where a single value was expected

[rf5896]

Hi all,

I am facing a very weird error, please help:

1. I have a Measure that reads the Currency Code called "Project Currency"

2. I am using an If/Switch Statement to check this Currency

3. In regards to what currency it is, I Multiple the exchange rate to a column called "Exp"

4. EXP is NOT a measure

5. I am facing this error : "A table of multiple values was supplied where a sigle value was expected"

6. My code : 

CurCol =

IF([Project Currency] = ("AED"), 'Union SAP Past/Forecast Exp'[Exp] * 4.2373,

IF([Project Currency] = ("QAR"), 'Union SAP Past/Forecast Exp'[Exp] * 4.1998,

IF([Project Currency] = ("OMR"), 'Union SAP Past/Forecast Exp'[Exp] * 0.44363,

IF([Project Currency] = ("SAR"), 'Union SAP Past/Forecast Exp'[Exp] * 4.32672))))

Note: I used this before and it worked flawlessly and is still working in my old Dashboard.

[PhilipTreacy · Accepted solution]

@rf5896 

Try this

CurCol =
IF( SELECTEDVALUE([Project Currency]) = "AED", 'Union SAP Past/Forecast Exp'[Exp] * 4.2373,
IF( SELECTEDVALUE([Project Currency]) = "QAR", 'Union SAP Past/Forecast Exp'[Exp] * 4.1998,
IF( SELECTEDVALUE([Project Currency]) = "OMR", 'Union SAP Past/Forecast Exp'[Exp] * 0.44363,
IF( SELECTEDVALUE([Project Currency]) = "SAR", 'Union SAP Past/Forecast Exp'[Exp] * 4.32672
)
)
)
)

Regards

Phil

[v-alq-msft · Accepted solution]

Hi, @rf5896 

You may try the following measure to see if it works.

CurCol =
switch(
     [Project Currency],
     "AED",sum('Union SAP Past/Forecast Exp'[Exp])*4.2373,
     "QAR",sum('Union SAP Past/Forecast Exp'[Exp])*4.1998,
     "OMR",sum('Union SAP Past/Forecast Exp'[Exp])*044363,
     "SAR",sum('Union SAP Past/Forecast Exp'[Exp])*4.32672
)

Best Regards

Allan

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

[PhilipTreacy · Accepted solution]

@rf5896 

Try this

CurCol =
IF( SELECTEDVALUE([Project Currency]) = "AED", 'Union SAP Past/Forecast Exp'[Exp] * 4.2373,
IF( SELECTEDVALUE([Project Currency]) = "QAR", 'Union SAP Past/Forecast Exp'[Exp] * 4.1998,
IF( SELECTEDVALUE([Project Currency]) = "OMR", 'Union SAP Past/Forecast Exp'[Exp] * 0.44363,
IF( SELECTEDVALUE([Project Currency]) = "SAR", 'Union SAP Past/Forecast Exp'[Exp] * 4.32672
)
)
)
)

Regards

Phil