Skip to main content

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1851) Share
Will Thompson's profile image

Will Thompson on 04 May 2017 01:32:23

In May 2017 Power BI Desktop started supporting creation of DAX measures when working in live connect mode to an external SSAS model: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/


Vote on this idea if you want support for calculated measures against multidimensional models too.

Comments (167)
Will Thompson's profile image Profile Picture

Yves on 05 Jul 2020 23:02:16

RE: Calculated measures when live connected to MDX cubes

Would love to see this feature available so I can get our Finance department of my back because Excel is sooooo much better :-)
Please make adding measures for multidimensional cubes available!

Will Thompson's profile image Profile Picture

Mike Foss on 05 Jul 2020 23:00:56

RE: Calculated measures when live connected to MDX cubes

Also Waiting for Multidimensional!! please update on status I know industry thinks multidimensional cubes are old news but multidimensional cubes need love too!

Will Thompson's profile image Profile Picture

Mads Berge-Lind on 05 Jul 2020 23:00:54

RE: Calculated measures when live connected to MDX cubes

Also waiting impatiently for the Multidimensional version of this!

Will Thompson's profile image Profile Picture

John Pratt on 05 Jul 2020 23:00:08

RE: Calculated measures when live connected to MDX cubes

YES! And I should also add as another user did that this is needed in Power BI Report Server and the associated Desktop RS, since everything seems to be separate at this point. I just hit this shortcoming this week, especially with wanting to do running totals and other custom measures.

Will Thompson's profile image Profile Picture

Pierre on 05 Jul 2020 22:59:40

RE: Calculated measures when live connected to MDX cubes

Would be a great addition. Most reports we have are against cubes - and the need to deploy cube changes everytime a measure for a specific report has to be added is not very effiecient.

Will Thompson's profile image Profile Picture

John Cullom on 05 Jul 2020 22:59:36

RE: Calculated measures when live connected to MDX cubes

Yup, you have to do this. You know you have to do this. Nobody uses stupid Tabular. It's for babies.

Will Thompson's profile image Profile Picture

Lee Cullom on 05 Jul 2020 22:59:36

RE: Calculated measures when live connected to MDX cubes

If you want to kill Tableau, this is the way.

Will Thompson's profile image Profile Picture

Alexander Stevens on 05 Jul 2020 22:58:49

RE: Calculated measures when live connected to MDX cubes

Yes, looking for this feaure!

Will Thompson's profile image Profile Picture

Luigi Pavlov on 05 Jul 2020 22:58:48

RE: Calculated measures when live connected to MDX cubes

Fully agree with the comments below, e.g. of August 30, 11 and 9. I would also appreciate to see some feedback (announcement) from Microsoft. They made a promise when they acquired DataZen, didn't they?

Will Thompson's profile image Profile Picture

Gavin Russell-Rockliff on 05 Jul 2020 22:58:06

RE: Calculated measures when live connected to MDX cubes

'Agreed. The ability to expose the base modelling features in PowerBI when connected to a live SSAS MD or tabular data source, are exactly what my current client need. Specifically:
- grouping / binning
- query multiple data sources
- add calculated members

Merged Idea (1)