Skip to main content

Power BI

Needs Votes

Calculated measures when live connected to MDX cubes

Vote (1582) Share
77326476 fdc8-ea11-a812-000d3a8faea9's profile image

77326476 fdc8-ea11-a812-000d3a8faea9 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 (146)
77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

adf7f3f6 3cb4-4979-b25a-1f9e2564120a on 05 Jul 2020 23:14:20

RE: Calculated measures when live connected to MDX cubes

updates?

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

048c643c 187b-4b57-81a6-7eee3765f035 on 05 Jul 2020 23:14:19

RE: Calculated measures when live connected to MDX cubes

Any update on this Idea ? Thanks

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

cea2ee0a 394a-457e-84c7-033e45f22a1e on 05 Jul 2020 23:13:09

RE: Calculated measures when live connected to MDX cubes

a must
thank you

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

13309f57 7011-410b-848d-75ddc9bf0f1d on 05 Jul 2020 23:12:42

RE: Calculated measures when live connected to MDX cubes

It has to be done as it will benefit both, Microsoft as a way to diffuse more largely the tool as it's a break for a lot of companies, and us, the customers, for who this is a must to have and move PowerBi from a good choice to the best choice

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

cc9fea09 ce8a-4097-b549-133a85c2470a on 05 Jul 2020 23:11:59

RE: Calculated measures when live connected to MDX cubes

This would be so amazingly useful. Right now our analyst team is hamstrung by this exact issue. Right now we are forced into one of two work-arounds. 1. We either have to export all data out of the cube, isolating ourselves to a fixed point in time for data, and then do analysis enabled by DAX... and do this export every time we need to update transactional data. The second option is that we have to wait on the development team to update the cubes when we need ANY kind of new calculation.

Being able to live connect and use the capabilities of DAX to build analysis - I can't even begin to tell you how great that would be.

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

e183482e 91a5-427b-a082-4cdc573837c8 on 05 Jul 2020 23:11:32

RE: Calculated measures when live connected to MDX cubes

Please, I want to start using Power BI but this is clearly a no-go without this functionality.

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

42023295 2962-43ca-8b90-ab37a6a99ebb on 05 Jul 2020 23:10:25

RE: Calculated measures when live connected to MDX cubes

I can't believe this has not even been planned by Microsoft...can you please give some hope to the customers who rely heavily on Multi-Dimensional models?

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

3043f7c5 4dcb-48e3-a977-cd91485cc89f on 05 Jul 2020 23:09:25

RE: Calculated measures when live connected to MDX cubes

We have an opportunity to migrate a client over to the Microsoft stack with SSRS and PowerBI but without support of Multidimensional for self-service we cannot propose this as a viable solution. Is there a timeline as to when this feature will be made available or Is it a strategic decision from Microsoft to get all clients over to tabular?

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

8220258f 0481-4eb3-bcb1-59be24c5ccde on 05 Jul 2020 23:09:10

RE: Calculated measures when live connected to MDX cubes

Please add this ASAP. Power BI has many strengths, but without calculated measures with MDX cubes, clients turn to other tools than Power BI.

77326476 fdc8-ea11-a812-000d3a8faea9's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:07:42

RE: Calculated measures when live connected to MDX cubes

PLEASE MAKE THIS HAPPEN! I have to used dreaded Pyramid until then