I am writing a DAX query into Tabular Cube. It keeps returning the errors: Failed to save modifcations to the server. Error returned: " A table of multiple values was supplied where a single value as expected.
Devices:=Calculate([Total Device], ALLEXCEPT('Codes','Codes'[A]),filter('Codes','Codes'[A]<>BLANK())))
Anyone could help out? Basically not just for this query. It will return the same error whever I write. Even I just copy the old query in, it will return the same error. Thanks in advanced
Hi @ask,Please share the formula of measure [Total Device] and more details. You must calculate [Total Device] based on different code, please create some fake data for further analysis.Best Regards,Angelia
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.