Skip to main content

    Power BI

    Needs Votes

    Calculated measures when live connected to MDX cubes

    Vote (1861) 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:57:42

    RE: Calculated measures when live connected to MDX cubes

    My organization also greatly needs this feature. We regularly use live connections to our multidimensional models. But can't feature any measures not embedded within the cubes. This is unacceptable, as it forces us to embed specific report calculations into our cubes incurring dev and deployment overhead, with very little reuse for the cube-embedded report-specific calculations.

    Will Thompson's profile image Profile Picture

    Minnie on 05 Jul 2020 22:57:18

    RE: Calculated measures when live connected to MDX cubes

    This feature would also Power BI SSRS get. This seem to be such a essential feature when connecting live to SSAS.

    Will Thompson's profile image Profile Picture

    Cleberson on 05 Jul 2020 22:57:01

    RE: Calculated measures when live connected to MDX cubes

    Any updates?

    Will Thompson's profile image Profile Picture

    Cherie on 05 Jul 2020 22:56:36

    RE: Calculated measures when live connected to MDX cubes

    Why can you add an MDX Calculated Measure in Excel 2016 using the OLAP Tools when Live Connected to a cube but you can not do this in Power BI? I would like to see the same OLAP Tools available in Power BI for live connections to cubes.
    Thank you.

    Will Thompson's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:56:29

    RE: Calculated measures when live connected to MDX cubes

    We need this urgently

    Will Thompson's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:56:14

    RE: Calculated measures when live connected to MDX cubes

    Hi, I really really need this. My originally vote was for this, not for Tabular Model. I have been waiting since lot time ago. Our datasets are too large for Tabular. MDX is right for us. We need to create calculated measures like other software does. Do it soon.

    Will Thompson's profile image Profile Picture

    Andrea Scharris on 05 Jul 2020 22:55:58

    RE: Calculated measures when live connected to MDX cubes

    Really need this feature asap. Please update this and let us know when on the horizon this will be addressed. With large, high volume dbs, we need to use MDX cubes and we need to do some minor calculations on the fly to be considered business "intelligence".

    Will Thompson's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:54:49

    RE: Calculated measures when live connected to MDX cubes

    I am opting out from Power BI. Enough waiting on you. I feel, tableau is still lot better. Spent too much on power Bi License without the tool actually being useful and trusting this feature gonna be released very soon.

    Will Thompson's profile image Profile Picture

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

    RE: Calculated measures when live connected to MDX cubes

    Have to agree with everyone on this, my vote on the original thread was for MDX cube calculated measures. We are now also nearly 3 months after the Tabular release and this idea hasn't even been put under review?

    Will Thompson's profile image Profile Picture

    Mike Foss on 05 Jul 2020 22:54:44

    RE: Calculated measures when live connected to MDX cubes

    Any update on when this will work with Multi-Dimensional Models? It currently works with Tabular models but it is super important that is work with all models as it does in Excel. This would accelerate the usage of Power BI in my organization.

    Merged Idea (1)