Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Calculated measures when live connected to MDX cubes

    Vote (1844) 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 (166)
    Will Thompson's profile image Profile Picture

    Frederic SImons on 10 Jun 2021 12:11:29

    RE: Calculated measures when live connected to MDX cubes

    Same here. Old measures can be modified but there is no way to create new ones.
    (btw the vote seems to be disabled)

    Will Thompson's profile image Profile Picture

    Peter Hartmann on 10 Jun 2021 06:26:49

    RE: Calculated measures when live connected to MDX cubes

    Same experience as everyone else. PLease Microsoft re-enable this. Even if it produces the occasional wrong result, it is up to the developer to ensure it is correct and it is so useful.

    Thank you.

    Will Thompson's profile image Profile Picture

    Kaarel Kivistik on 04 Jun 2021 10:48:16

    RE: Calculated measures when live connected to MDX cubes

    So I talked with Microsoft Support. Dev team has switched it off in March update and won't tell if this will be enabled in the future on not. Vote...

    Will Thompson's profile image Profile Picture

    Kaarel Kivistik on 02 Jun 2021 12:31:16

    RE: Calculated measures when live connected to MDX cubes

    I can confirm. It worked before with MD model when connection via Power BI dataset. It doesn't work currently. Please add this functionality back.

    Will Thompson's profile image Profile Picture

    Kurt Denolf on 19 May 2021 15:07:41

    RE: Calculated measures when live connected to MDX cubes

    As stated below with the 2021 March version this solution does not work anymore. Please give us this workaround at least back !!!

    Will Thompson's profile image Profile Picture

    Emilie CHARPY on 14 Apr 2021 13:23:21

    RE: Calculated measures when live connected to MDX cubes

    Same problem for us : with the 2021 March version this solution does not work anymore. This is SO IMPACTFUL for all the reports we have been building this way. Our all community will be progressively impacted as version upgrades are done automatically... Is there any possible roll back or evolution to (re)open the possibilities on MDX datasources ?

    Will Thompson's profile image Profile Picture

    Salonic Xaug on 14 Apr 2021 10:01:20

    RE: Calculated measures when live connected to MDX cubes

    '@andrey Yakimov,

    Seems that with the March version the method you described does not work anymore...
    Do you have same problem or you do not use MDX SSAS Cubes anymore ?

    We still need this functionality to be definitivly implemented in powerbi desktop

    Will Thompson's profile image Profile Picture

    on 09 Dec 2020 00:48:18

    RE: Calculated measures when live connected to MDX cubes

    Enable DAX support for reports using live connection to SQL Server Multi-Dimensional in Power BI Desktop and Power BI Service. Simple DAX measures like: Amount in Thousands = [Measure]/1000. TGT Variance = [Actual]-[Target] etc. could be created on report level and would be massively useful. Now I must extend enterprise data model (cube) every time when I need something like [Measure]/1000 in one Power BI report. This is crazy. I understand, that because Multidimensional don’t understand concept of Table, so some DAX functions will not work. This should be developer’s responsibility to develop and test. If intellisense doesn’t work also isn’t an issue. Better some functionality, then none.

    Will Thompson's profile image Profile Picture

    Power BI User on 10 Jul 2020 17:20:40

    RE: Calculated measures when live connected to MDX cubes

    we definitely still need this

    Will Thompson's profile image Profile Picture

    Miriam Lara on 06 Jul 2020 00:13:34

    RE: Calculated measures when live connected to MDX cubes

    We really need to calculated measures against multidimensional models . Using Live Connection we need to be able to create DAX measures. thanks. Miriam

    Merged Idea (1)