Skip to main content
Microsoft Idea

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1843) 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 User on 05 Jul 2020 22:47:52

RE: Calculated measures when live connected to MDX cubes

I voted for MD in the previous idea that has been closed!

Will Thompson's profile image Profile Picture

Peppe on 05 Jul 2020 22:47:52

RE: Calculated measures when live connected to MDX cubes

Definitely a must-have to enable us switching to PowerBI.

Disappointed to not see this functionality released along with DAX custom calculations. Would really appreciate to see MS supporting his MD community, Tabular is not fully ready yet to enable a transition from MD -> Tabular....

Will Thompson's profile image Profile Picture

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

RE: Calculated measures when live connected to MDX cubes

The absence of calculated measures against live connected multidimensional cubes is major reason why we can't migrate to Power BI, and it's a major disappointment that the original idea was not implemented as described.

Will Thompson's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:47:45

RE: Calculated measures when live connected to MDX cubes

Given that our current and major investment with SSAS resides in MD its dissapointing that creating calculated measures against these types of cubes is a let down. I get that you're trying to push tabular but the trying to get powerbi pushed through industry is tough if we are also required to migrate all existing SSAS tools to tabular. Won't fly in my organization. PLEASE add calculated measures for SSAS MD and we will move over the PowerBI

Will Thompson's profile image Profile Picture

Brandon Forbes on 05 Jul 2020 22:47:44

RE: Calculated measures when live connected to MDX cubes

My original vote was also for SSAS MD support, we did not need the tabular. Agree with everyone the fact this was not included is disappointing

Will Thompson's profile image Profile Picture

AdamP on 05 Jul 2020 22:47:44

RE: Calculated measures when live connected to MDX cubes

As per other comments, my vote originally was for SSAS MD support. We need this urgently.

Will Thompson's profile image Profile Picture

Jele on 05 Jul 2020 22:47:42

RE: Calculated measures when live connected to MDX cubes

In line with other comments: the votes from the previous idea should be carried over to this one. We should not start back from zero. Or please reopen the previous one!

Also please can you confirm that this idea is already underway as this was assumed in the previous idea?

Will Thompson's profile image Profile Picture

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

RE: Calculated measures when live connected to MDX cubes

Wow, what a surprise! My vote was useless in the original Calculated measures topic, as I wanted it for MD. Really, can't you keep consider the critical mass that still usesMD heavely? We are always left for the end...

Will Thompson's profile image Profile Picture

Aaron Shumaker on 05 Jul 2020 22:47:39

RE: Calculated measures when live connected to MDX cubes

So my votes on the other feature didn't mean what I thought it meant? You should have closed that feature in the beginning and split out two new. I think you'd have seen mdx was preferred. Very few people are going to see the change and actually come move their votes. From the beginning mdx has gotten the cold shoulder in so many ways. Why would you try to force your customers onto tabular when there are so many scenarios that are more difficult. Tabular is a solution that makes 90% of scenarios easier and 10% nearly impossible. It's the same mistake MS made with ASP Web Forms in effort to make development easier they painted you into a corner that made alot of things nearly impossible.

Will Thompson's profile image Profile Picture

Tonyh on 05 Jul 2020 22:47:39

RE: Calculated measures when live connected to MDX cubes

I was hoping that multidimensional is supported as part of this release :(. Is there a timeline when this feature will be available?

Merged Idea (1)