Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :
Note: I used this before and it worked flawlessly and is still working in my old Dashboard.
Solved! Go to Solution.
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
Proud to be a Super User!
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.
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.
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |