Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using a LIVE connection to SSAS has anyone had trouble getting calculated members to show up in Power BI Desktop?
Solved! Go to Solution.
It looks like [Dim Profitability Account].[Profitability] is a user hierarchy. As stated here, in the section "Dimension Calculated Members":
...calculated members on user hierarchies are not exposed in Power BI.
Chris
Hi @aaronlebato,
Please check if you set the Visible for the calculated member as True.
If it's true, when you connect live to SSAS cube in desktop, the calculated member should display.
Best Regards,
Qiuyun Yu
Hi QIuyun Yu
I have tried this, but still not show in PowerBI, the member calculation is not from user Hierarchy but from real Member of dimension.
What i miss ?
Thanks
Yudhi H
Hi v-qiuyu-MSFT ,
Yes. The calculated member is set to visible. What is odd is that the member shows up in Excel but does not show up in Power BI.
See "Margin" member below and as well as some screens.
It looks like [Dim Profitability Account].[Profitability] is a user hierarchy. As stated here, in the section "Dimension Calculated Members":
...calculated members on user hierarchies are not exposed in Power BI.
Chris
Thanks Chris! Although not the answer I wanted to hear obviously, clearly the correct answer. By the way, I'm a student of yours. Your content on https://projectbotticelli.com/ is by far the best I've come across and has helped me expand into MDX from a career in SQL based reporting. I'm not where I want to be yet but I would still be at the drawing board without your help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.