Skip to main content

    Power BI

    Needs Votes

    Calculated measures when live connected to MDX cubes

    Vote (1858) 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 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!

    Will Thompson's profile image Profile Picture

    Charleen 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

    Will Thompson's profile image Profile Picture

    Ludwig Coosemans 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...

    Will Thompson's profile image Profile Picture

    Krzysztof Zajączkowski 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 :).

    Will Thompson's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:48:28

    RE: Calculated measures when live connected to MDX cubes

    Need it yesterday

    Will Thompson's profile image Profile Picture

    Matt Kowalski on 05 Jul 2020 22:48:17

    RE: Calculated measures when live connected to MDX cubes

    Yes, absolutely!

    Will Thompson's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:48:13

    RE: Calculated measures when live connected to MDX cubes

    Yes please!

    Will Thompson's profile image Profile Picture

    Power BI User 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.

    Will Thompson's profile image Profile Picture

    Todd Gilmore 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.

    Will Thompson's profile image Profile Picture

    Andrejs Gordijenko 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

    Merged Idea (1)