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:17:14

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

    Our users will very much appreciate having that feature.

    's profile image Profile Picture

    rafik on 05 Jul 2020 22:16:00

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

    Every single reporting tool that connects to SSAS provides this functionality ( Excel, SSRS, Pyramid, etc....) we really need this feature.

    's profile image Profile Picture

    Nosh on 05 Jul 2020 22:15:59

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

    We are using an SSAS Cube and/or Tabular model as a data source and we need to create calculations when in Live/DirectQuery mode in Power BI.

    's profile image Profile Picture

    Kelly Bowen-McCombs (She/Her) on 05 Jul 2020 22:13:48

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

    Also for OLAP cubes.

    's profile image Profile Picture

    Morten Jørgensen on 05 Jul 2020 22:08:05

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

    It would be highly beneficial if we could write our own Calculated fields in DAX directly in the model or "on top" of a current SSAS Tabular which we can connect to