cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

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

Hi all,

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.

2 ACCEPTED SOLUTIONS
Super User

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

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

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors