Skip to main content

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1857) 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

Christof Leeb on 23 Jun 2021 10:13:30

RE: Calculated measures when live connected to MDX cubes

MOST NEEDED FEATURE FOR ALL SSAS USERS ( MIGRATING TO TABULAR MODEL IS HORRIBLE (THERE IS NO MIGRATION SUPPORT TOOL FROM MS ) AND THERE ARE STILL TOO MANY UNSUPPORTED FEATURES) --> EXCEL HAS A BETTER CUBE SUPPORT --> WE REALLY LIKE PBI (EVEN on THE PBI RS) (HOW MANY VOTES ARE NECESSARY THAT MS SUPPORTS USERS WITH GOOD SOLUTIONS ?) ( Another interresting link : https://blog.crossjoin.co.uk/2020/07/12/migration-from-analysis-services-multidimensional-your-feedback-needed/ ....just read the blog entries)

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

Merged Idea (1)