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

2d1b2992 2c6a-4d71-8370-7a02e9614e95 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

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

a442d276 f7e8-49a5-b461-97b785d3599c 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...

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

dcb5a934 cd41-4000-8ad7-16e45b8c5532 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 :).

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

b8bfcd21 c8db-4af7-ba56-7bda56233205 on 05 Jul 2020 22:48:28

RE: Calculated measures when live connected to MDX cubes

Need it yesterday

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

06b35ebb ac3a-473f-bd05-1ec95c8d5c15 on 05 Jul 2020 22:48:17

RE: Calculated measures when live connected to MDX cubes

Yes, absolutely!

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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:48:13

RE: Calculated measures when live connected to MDX cubes

Yes please!

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

9116d430 15e8-4398-b0f3-327d71c7e8eb 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.

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

c6d744b8 eea2-44c3-903c-4c7edb7dbbbf 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.

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

735af055 87c0-403f-b1ac-180c88a25ca8 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

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

c7b61285 f5e9-4c97-bf69-b5ab9b56209f 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!