Forum Discussion
SSAS report measure issue
I am connecting to a SSAS model with live connection, the report works fine. I can even add one or two report measures to the report and they also work fine. When I add a third measure an error ...
Getting exactly the same issue here, connected to Azure AS, we get this error when the third measure is created.
Here's a simple workaround to avoid this error:
Instead of clicking on "New measure" on the toolbar, just right-click on any table in the fields list and choose "New measure" from the dropdown menu.
I've noticed that when the error occurs, the new measure is created without a home table, and is listed at the top of the fields list, this may be what's causing the error. With the workaround, it is created on whichever table the right-click was performed on.