Skip to main content

Power BI

Needs Votes

Calculated measures in multi-dimensional SSAS cubes

Vote (64) Share
Marc Bellanger's profile image

Marc Bellanger on 21 Jun 2017 21:37:36

There appear to be a few posts requesting calculated measures in 'cubes' which seems to get interpreted as a request for tabular cubes in the feedback and completion of the task. But we need the ability to add custom calculated measures in Power BI when directly connected to a multi-dimensional SSAS cube.

Whether it is enabled through MDX or DAX, this would open the door for us. Our company (and I'm sure many others) have deployed a few hundred MDX cubes over the years but we don't want to start customizing them all to include every little calculation that a user of the cube dreams up. The customizations would never stop. The fact that PBI doesn't allow custom measures on multi-dimensional cubes is a huge hindrance to our adoption of Power BI.

Please vote!

Comments (3)
Marc Bellanger's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:30

RE: Calculated measures in multi-dimensional SSAS cubes

Totally agree with Matt there

Marc Bellanger's profile image Profile Picture

Denis on 05 Jul 2020 22:52:14

RE: Calculated measures in multi-dimensional SSAS cubes

I think it's the same:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c

Marc Bellanger's profile image Profile Picture

Denis on 05 Jul 2020 22:52:14

RE: Calculated measures in multi-dimensional SSAS cubes

sorry...this one:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19140997-calculated-measures-when-live-connected-to-mdx-cub