Skip to main content

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1582) Share
77326476 fdc8-ea11-a812-000d3a8faea9's profile image

77326476 fdc8-ea11-a812-000d3a8faea9 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 (146)
77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

4cbe24b7 ab47-4bf8-9c2c-ec00118b35ca 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....

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

69d781d6 6a2d-4f2f-be36-9d24a3ded863 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.

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 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

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

090f412d 531f-42f1-abc9-57d9c903a231 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

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

2ddce2eb 067f-4c51-a5c2-06b63e5753d8 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.

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

b3dab914 0e85-4cce-9d1c-c506d172a897 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?

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

6dba526f af3d-4d2a-afd2-094da3bce204 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...

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

fd0c30f8 c0ec-41e7-8ae4-946a8ea934e2 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.

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

d89a6fe7 7510-455a-baea-83efa8b3fd3b 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?

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

766393e2 4480-e811-a961-000d3a1bece3 on 05 Jul 2020 22:47:38

RE: Calculated measures when live connected to MDX cubes

We need this functionality for Multidimensional cubes. We don't use tabular.