How can we improve Power BI?

Calculated measures when live connected to MDX cubes

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.

652 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Will ThompsonAdminWill Thompson (Product Manager, Power BI, Microsoft Power BI) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    56 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • PierrePierre commented  ·   ·  Flag as inappropriate

        Would be a great addition. Most reports we have are against cubes - and the need to deploy cube changes everytime a measure for a specific report has to be added is not very effiecient.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Yup, you have to do this. You know you have to do this. Nobody uses stupid Tabular. It's for babies.

      • Luigi PavlovLuigi Pavlov commented  ·   ·  Flag as inappropriate

        Fully agree with the comments below, e.g. of August 30, 11 and 9. I would also appreciate to see some feedback (announcement) from Microsoft. They made a promise when they acquired DataZen, didn't they?

      • Anonymous commented  ·   ·  Flag as inappropriate

        Agreed. The ability to expose the base modelling features in PowerBI when connected to a live SSAS MD or tabular data source, are exactly what my current client need. Specifically:
        - grouping / binning
        - query multiple data sources
        - add calculated members

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • MinnieMinnie commented  ·   ·  Flag as inappropriate

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

      • CherieCherie commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Andrea ScharrisAndrea Scharris commented  ·   ·  Flag as inappropriate

        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".

      • Anonymous commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        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?

      • Mike FossMike Foss commented  ·   ·  Flag as inappropriate

        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.

      • Anonymous commented  ·   ·  Flag as inappropriate

        really strange that this is still a hard showstopper...from technical side there shouldn't be any challenges doing the same like available already for tabular for MD? Tools like https://www.xlcubed.com/ can do that since Long time and works great

      ← Previous 1 3

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.