Calculated measures when live connected to MDX cubes
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.
Filip Bouckaert commented
Need this !!
support for calculated measures against multidimensional models (Cube)
Would love to see this feature available
With this feature not yet updated to Power BI, unable to use the application at its best.
Unable to work on dashboards with such restrictions of not being able to write a dax against the live cube.
Very much disappointed.
FRUSTRATING if anyone from Power BI team reading these comments!!!!
Without that we cannot:
1- deal with (Blank) on cards
2- Show selected filters in text box
3- Query from more than one data source
and so many other things that other developers trying to do.
We cannot move to Tabular model Until a TRUE MANY-TO-MANY table configuration is possible or to have MULTIPLE RELATION between fact tables and Date table implemented.
Cannot use hack to do one or another.
Microsoft should consolidate all these feature before promoting new features.
Desperately need this feature
Man, they took more than year to atleast update the status ? Damn, a clear ignorance.
Definitely mandatory Feature in Power BI!!! Cannot create every time a measure in the cube when I need one.
Ahmer Shahid commented
This is the need of business and not having it is a deal breaker
How can an idea from an year ago, with 1087 votes and hasn't even been evaluated...
I know microsoft is trying to force companys for tabular model, but there are several companys that still use multidimensional models...
I was surprise to see that this feature was not implemeted yet ... I need this but I can't ... The problème is that I don't want to create all my measures in the SSAS cube !
I am waiting for an update soon ;)
Yes please add this feature, it will be very useful.Also when we select a date hierarchy into a basic filter, the "relative" option is missing, this is due to data type set as text for the date field. IF this can be fixed on Power BI side, it would be great.
Yes please!!!!!!!!!!! It's working with tabular, surely you can get it working with multi dimensional models.
Every other idea with more than 1000 votes has a reply from Microsoft against it but this one, and this is the single most important thing for Power BI adoption in the FTSE 100 company I work for.
Trevor D Hill commented
Bizarre that this isn't available.
René Imthorn commented
Should give us a real ROI!
René Imthorn commented
Our business needs it!
Could you please provide an update on this topic ?
Is it something that can not be implemented in power bi ?
This would be a major benefit, looking for udpates as well.
Michael Henry commented