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)
- Merged Idea (1)
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)
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)
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.
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...
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.
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 !!!
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 ?
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
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.
RE: Calculated measures when live connected to MDX cubes
we definitely still need this