Skip to main content

Power BI

New

DAX for SSAS Multidimensional

Vote (112) Share
Jiri Neoral's profile image

Jiri Neoral on 26 Apr 2019 15:40:03

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.

Comments (2)
Jiri Neoral's profile image Profile Picture

bb9ed867 4726-4008-ba2e-ba522c37568e on 06 Jul 2020 00:04:17

RE: DAX for SSAS Multidimensional

I found workaround and I covered it in this blog post. It is not a solution, but just workaround http://www.neoral.cz/2019/11/dax-for-analysis-services.html

Jiri Neoral's profile image Profile Picture

d67296aa ce7d-4b79-8ed0-9352e109bae1 on 05 Jul 2020 23:58:29

RE: DAX for SSAS Multidimensional

I believe that this idea is the same as :
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when-live-connected-to-mdx-cub