Skip to main content

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1857) 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 23:14:48

RE: Calculated measures when live connected to MDX cubes

Any update?

Will Thompson's profile image Profile Picture

Ela Wasserman on 05 Jul 2020 23:14:20

RE: Calculated measures when live connected to MDX cubes

updates?

Will Thompson's profile image Profile Picture

Fred on 05 Jul 2020 23:14:19

RE: Calculated measures when live connected to MDX cubes

Any update on this Idea ? Thanks

Will Thompson's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:09

RE: Calculated measures when live connected to MDX cubes

a must
thank you

Will Thompson's profile image Profile Picture

OM on 05 Jul 2020 23:12:42

RE: Calculated measures when live connected to MDX cubes

It has to be done as it will benefit both, Microsoft as a way to diffuse more largely the tool as it's a break for a lot of companies, and us, the customers, for who this is a must to have and move PowerBi from a good choice to the best choice

Will Thompson's profile image Profile Picture

Matt M. on 05 Jul 2020 23:11:59

RE: Calculated measures when live connected to MDX cubes

This would be so amazingly useful. Right now our analyst team is hamstrung by this exact issue. Right now we are forced into one of two work-arounds. 1. We either have to export all data out of the cube, isolating ourselves to a fixed point in time for data, and then do analysis enabled by DAX... and do this export every time we need to update transactional data. The second option is that we have to wait on the development team to update the cubes when we need ANY kind of new calculation.

Being able to live connect and use the capabilities of DAX to build analysis - I can't even begin to tell you how great that would be.

Will Thompson's profile image Profile Picture

Fabien Marrone on 05 Jul 2020 23:11:32

RE: Calculated measures when live connected to MDX cubes

Please, I want to start using Power BI but this is clearly a no-go without this functionality.

Will Thompson's profile image Profile Picture

Yang Yuan on 05 Jul 2020 23:10:25

RE: Calculated measures when live connected to MDX cubes

I can't believe this has not even been planned by Microsoft...can you please give some hope to the customers who rely heavily on Multi-Dimensional models?

Will Thompson's profile image Profile Picture

Warren Allworth on 05 Jul 2020 23:09:25

RE: Calculated measures when live connected to MDX cubes

We have an opportunity to migrate a client over to the Microsoft stack with SSRS and PowerBI but without support of Multidimensional for self-service we cannot propose this as a viable solution. Is there a timeline as to when this feature will be made available or Is it a strategic decision from Microsoft to get all clients over to tabular?

Will Thompson's profile image Profile Picture

Power BI User on 05 Jul 2020 23:09:10

RE: Calculated measures when live connected to MDX cubes

Please add this ASAP. Power BI has many strengths, but without calculated measures with MDX cubes, clients turn to other tools than Power BI.

Merged Idea (1)