Create calculated measures on top of a live SSAS connection

[pbiideas1]

Creating a live connection to SSAS MD or Tabular is working just fine. However, it would be very beneficial to have the ability to create new calculated measures (in MDX). Just like we can create our own calculated measures when writing an MDX query for a SSRS dataset.

[fbcideas_migusr]

Why not do this for Multidimensional and then close the idea? Is calculated measures on SSAS Multidimensional scheduled for June or a future month?

[adrianpb]

Hi Will I'm totally Agree with previous comments, this is not complete. Please correct the status of the idea and tell us when will it be posible for Multidimensional SSAS models. Thank you.

[stuart_charles]

Brilliant news, thank you! This seems to work exactly the way I hoped. Looking forward to also seeing calculated columns.

[9188040d-6c6103]

Please add the ability to create MDX calculations (SSAS Multidimensional) in a report like we can do in Excel and SSRS. It's very important to use

[DJhaveri1]

This will be very useful for user to create custom measures for their reports. Hopefully this will be available in next release.

[mhwa]

Agree, I was hopeful with this release that it would support multidimensional models. I actually couldn't figure out why it wasn't working until I came back to this thread to see these comments. Will, could you comment on when multidimensional models will be supported?

[alexandre_duroc]

Excellent. Thanks to the PBI team for that great functionality!!!

[pg4]

Fantastic - also please add the future to support MultiDimensional as well.

[chass]

Check out what Will's dev team delivered this month! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/ Report level measures for live connections to Analysis Services tabular models & Power BI service datasets If you are creating a live connection to a tabular Analysis Services server or a Power BI service dataset, you can now create new measures using DAX. These measures will not be part of the model. However, they will behave just like measures defined in imported models, meaning you can set their data type and formatting, see error messages when you break the measure expression, and use intellisense when editing the expressions. Also, they can be used in reports published to the Power BI service and used in visuals pinned to dashboards. You create them in just the same way as you would for an imported model, from the New Measure button in the ribbon, or by right clicking in the field list. We currently only support report measures a live connection against Analysis Services Tabular models. You won’t be able to create measures when connected to Multidimensional cubes, but we’ll consider this for a future release based on your feedback.

[katta_trinathre]

Wow.. this is amazing. Please add this for Multi Dimensional Cubes too. We would love to have this. I am sure, reports have more power to show with live connection. Cant Wait to See this!!!