Forum Discussion
summary stats
thanks for this code, it looks logical. I was able to update my dashboard to include the table and field name in my system and the 2 column Type and the measure Customer_Stats both save without error. but when I go to use the customer_stats measure and/or the type field I get the error.
query(2,1) a table of multiple values was supplied where a single value was expected.
thoughts
Hi Anonymous ,
There may be some problem in your code, this error will appear when your code will return multiple values like lists/table but Power BI only support single value.
We can see that my measure above will all return single aggregate values.
If this still couldn't help you solve your problem please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.