Forum Discussion
Analysis Services Calculated Members (not on Measures) not showing up in Power BI Desktop
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 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.
Advocate VIt 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.