I connect with Power BI Desktop (latest version) to my SQL Server Analysis Service and i create a new Measure.
For example: NewMeasure = Sales[Value] / Sales[Quantity]. All works perfectly.
But when i try to use Sales[Value] or Sales[Quantity] in other visualization it returns me an error: "Unexpected exception" and also when i use this two Measures with Management Studio or Excel, it always gives me error "Unexpected exception".
Thanks in advance for the replies and sorry for my bad english.
Solved! Go to Solution.
What version of your SQL Server Analysis Service(SSAS) and how do you create the two measures(Sales[Value] and Sales[Quantity]) in Analysis Service data model? Please make sure that you have installed the latest Service pack for your SSAS.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!