Forum Discussion

Regular Visitor

9 years ago

Solved

Analysis Services Calculated Members (not on Measures) not showing up in Power BI Desktop

Using a LIVE connection to SSAS has anyone had trouble getting calculated members to show up in Power BI Desktop?

cwebb
9 years ago
It looks like [Dim Profitability Account].[Profitability] is a user hierarchy. As stated here, in the section "Dimension Calculated Members":
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/#capabilities-and-features-of-ssas-md
...calculated members on user hierarchies are not exposed in Power BI.

Chris

Icon for Community Support rank

Community Support

9 years ago

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

Regular Visitor

8 years ago

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