Skip to main content

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1861) 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

Power BI Ideas Admin on 05 Jul 2020 22:49:00

RE: Calculated measures when live connected to MDX cubes

Always wondered why it wasn't included in the first place...
Would love to have this option!

Will Thompson's profile image Profile Picture

Charleen on 05 Jul 2020 22:48:55

RE: Calculated measures when live connected to MDX cubes

To be able to use the new measure in the live connect mode would be fantastic

Will Thompson's profile image Profile Picture

Ludwig Coosemans on 05 Jul 2020 22:48:55

RE: Calculated measures when live connected to MDX cubes

This was a well-appreciated feature in DataZen which we were using when Microsoft acquired it. MS then promised to integrate DataZen into their own platform (now called Power BI), so it should only be a matter of time. Hopefully not for long anymore because many of our users have already started talking to us about Qlikview: they want to read the data warehouse (the data base!) in order to make their own reports, while all the value is already in the MD Cubes...

Will Thompson's profile image Profile Picture

Krzysztof Zajączkowski on 05 Jul 2020 22:48:28

RE: Calculated measures when live connected to MDX cubes

I was also thinking that this will be fixed for multidimensional in the May update. It's a shame that despite the old thread already got 1,227 votes, we now need to vote again for MD.

I think that most users were voting for multidimensional in the first place :).

Will Thompson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:48:28

RE: Calculated measures when live connected to MDX cubes

Need it yesterday

Will Thompson's profile image Profile Picture

Matt Kowalski on 05 Jul 2020 22:48:17

RE: Calculated measures when live connected to MDX cubes

Yes, absolutely!

Will Thompson's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:48:13

RE: Calculated measures when live connected to MDX cubes

Yes please!

Will Thompson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:47:54

RE: Calculated measures when live connected to MDX cubes

As others have mentioned, I think we all though multidimensional models would be supported based on the other idea thread...disappointing that we have to start a new thread to get this feature.

Will Thompson's profile image Profile Picture

Todd Gilmore on 05 Jul 2020 22:47:53

RE: Calculated measures when live connected to MDX cubes

Fortune 200 company with many MD models in place. It's critical that MS enables this functionality so users can be empowered to create their own measures on the fly.

Will Thompson's profile image Profile Picture

Andrejs Gordijenko on 05 Jul 2020 22:47:52

RE: Calculated measures when live connected to MDX cubes

Lack of MD support is indeed a major holdup for several of our clients. They would love to migrate to Power BI, but now we have to "reinvent the wheel" to implement their requirements, instead of just switching to PowerBI

Merged Idea (1)