Forum Discussion
Multiple value was supplied where a single value was expected error
Hi niteshtrehan89 ,
You cannot use the VALUES and then a = with a single value you need to redo all your syntax to:
SELECTEDVALUE(Summary[Header]) = "Asset Avg Balance" && SELECTEDVALUE(Summary[MIS Value]) = "YTD Budget"Hi niteshtrehan89 ,
The issue lies with the VALUES function. It returns a list of distinct values, which can be used for counting, filtering, or summing, but it doesn't provide a single value. In your IF function logic, a single value is expected to evaluate the conditions. I recommend replacing the VALUES function with the SELECTEDVALUE function, which returns a single value if one exists, or BLANK otherwise.
I hope this helps! If it does, please mark it as a solution and consider giving a Kudos.
You can learn more about VALUES function here
Thank you!
Hi niteshtrehan89 ,
The issue lies with the VALUES function. It returns a list of distinct values, which can be used for counting, filtering, or summing, but it doesn't provide a single value. In your IF function logic, a single value is expected to evaluate the conditions. I recommend replacing the VALUES function with the SELECTEDVALUE function, which returns a single value if one exists, or BLANK otherwise.
I hope this helps! If it does, please mark it as a solution and consider giving a Kudos.
You can learn more about VALUES function here
Thank you!