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

5aaf90ab a69a-4a43-bbc8-9dbf1e0c2208 on 05 Jul 2020 22:54:21

RE: Calculated measures when live connected to MDX cubes

Vital to adoption of the product for a number of my customers.

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

fd0c30f8 c0ec-41e7-8ae4-946a8ea934e2 on 05 Jul 2020 22:53:00

RE: Calculated measures when live connected to MDX cubes

No surprise this jumped right to the top ideas. It's what we voted for originally! It'd have even more votes if you didn't hijack the other feature request and only implement it in half the product, and pretend we weren't voting for MDX cube support all along! 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. This and named sets are important features to producing flexible reports that will meet customer needs. The work arounds are ugly and produce a poor experience for the customer.

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

6d40a3aa b6dd-4d9c-8e43-43b395d14844 on 05 Jul 2020 22:52:42

RE: Calculated measures when live connected to MDX cubes

The current Live Connection is very limited as it doesn't allow to generate calculated measure and/or label renaming. This should work the same way SSRS datasets work.

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

88a92dbb 67bd-42f9-bfb4-781f2baccd43 on 05 Jul 2020 22:51:28

RE: Calculated measures when live connected to MDX cubes

Guys, Please post us the updates if any? We have been waiting on this since many months. trusting you guys, we still stick to Power BI. If its delayed, whats the point getting a tool that doesn't support the set up we have?

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

4a048df3 ebb2-e811-a978-000d3a1bee29 on 05 Jul 2020 22:51:11

RE: Calculated measures when live connected to MDX cubes

Really keen for the calculated measures on Multi-Dimensional SSAS model!

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

20a15d13 d263-4ce9-a46e-314b9d8ab12c on 05 Jul 2020 22:50:54

RE: Calculated measures when live connected to MDX cubes

I need it

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

daaad28d 7ea3-425b-a0ab-1e46d935d604 on 05 Jul 2020 22:49:46

RE: Calculated measures when live connected to MDX cubes

A live connection to the SSAS tabular model is no option for us. So I´m really waiting for this solution!

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

88a92dbb 67bd-42f9-bfb4-781f2baccd43 on 05 Jul 2020 22:49:12

RE: Calculated measures when live connected to MDX cubes

Please dont say that, this has to go Planned--->Started-->Wait for an year--->Completed :O

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

61563012 a4aa-42b0-9da2-5d669cf0d376 on 05 Jul 2020 22:49:12

RE: Calculated measures when live connected to MDX cubes

Not every user of SSAS has a machine with beefy RAM thus invalidating using tabular models. By not offering Multidimensional support you are yourself discouraging people from using a Microsoft Tech, why so? Make it at parity!

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

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