Forum Discussion
single value was expected?
I get the below error: My code in the Role is: [Key_Customer] IN SELECTCOLUMNS( FILTER( 'Customer', LOOKUPVALUE( 'Customer'[Key_Customer], 'Customer'[Lea...
v-henryk-mstf
Community Support
Community SupportHi Anonymous ,
That error usually arises by using a function which expects a scalar value but yet the computation of the code returns a tableor more than 1 value.
You probably just want to do something like the similar posts as below: Solved: A table of multiple values was supplied where a si... - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.