Skip to main content
Microsoft Idea

    Power BI

    Completed

    Create calculated measures on top of a live SSAS connection

    Vote (1142) Share
    's profile image

    on 02 Feb 2016 21:57:09

    Creating a live connection to SSAS MD or Tabular is working just fine. However, it would be very beneficial to have the ability to create new calculated measures (in MDX). Just like we can create our own calculated measures when writing an MDX query for a SSRS dataset.

    Administrator on 04 May 2017 01:33:35

    Hi everyone! I'm really excited to announce that you can now create calculated measures on top of a live SSAS connection! The measures are stored in your report definition and sent along with the queries to your model. You can read more information about that here https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/. We're planning support for quick measures in this mode soon, and also looking at expanding this further based on your feedback: - If you want calculated columns/tables you can vote here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140907-create-calculated-columns-when-using-ssas-live-con - If you want support over SSAS Multidimensional, vote here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when-live-connected-to-mdx-cub Thanks everyone!

    Comments (145)
    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:46:35

    RE: Create calculated measures on top of a live SSAS connection

    Great, has any deadline been given yet? Really need this.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:46:33

    RE: Create calculated measures on top of a live SSAS connection

    Absolutely needed ASAP - This is a make or break feature for us to use Power BI against our existing cubes, as well as moving forward. PLEASE update when/if this will be released. Thanks!

    's profile image Profile Picture

    Mike Foss on 05 Jul 2020 22:46:31

    RE: Create calculated measures on top of a live SSAS connection

    Can we make sure it function with Multi Dimensional models as we just like excel.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:45:53

    RE: Create calculated measures on top of a live SSAS connection

    We need this for Multidimensional yes or yes... the current status of the Multidimensional functionalities in Power BI is quite limited... we need formatting, calculated measures, being able to connect live using mdx select statements, etc.

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:45:53

    RE: Create calculated measures on top of a live SSAS connection

    Hello Will Thompson,

    Can you update the community on when this feature will be released, even if you can only give us a broad time frame. Many of us need to set expectations with our self-service business users regarding when this feature will be released.

    Thank You,

    Chris Miller

    's profile image Profile Picture

    Jörgen Hasselgren on 05 Jul 2020 22:45:47

    RE: Create calculated measures on top of a live SSAS connection

    This will really make a big change

    's profile image Profile Picture

    jerome P on 05 Jul 2020 22:45:44

    RE: Create calculated measures on top of a live SSAS connection

    we are all waiting for this :) it will be the biggest feature you can deliver!!! (of the month ;) )

    's profile image Profile Picture

    Rajiv on 05 Jul 2020 22:45:42

    RE: Create calculated measures on top of a live SSAS connection

    Any updates on this as this?

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:45:41

    RE: Create calculated measures on top of a live SSAS connection

    I'm frustrated that none of my DAX expressions are not allowed with DirectQuery.

    's profile image Profile Picture

    Chris Klimm on 05 Jul 2020 22:45:35

    RE: Create calculated measures on top of a live SSAS connection

    It is frustrating that so many features get disabled with a Live Connection to SSAS. What are the plans for the Live Connection mode. Will we see functions like Quick Calcs, Grouping, Binning, Renaming columns etc make their way into the live connection mode?