Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
bjarvis100
Regular Visitor

Calculated members not showing in Power BI Desktop

Hi

 

I know similar posts have been made, but they don't seem to answer my question.....

 

I have a dimension with an attribute (not key attribute) Margin.  The Margin attribute has a couple of Calculated Members which are not siblings of the All member and the attribute is not a parent child attribute.

 

From this document , I expected them to be displayed in the Margin attribute hierarchy when I bring it onto the Power BI report.  

 

From Document

Multidimensional models expose calculated members on attribute hierarchies as values of a column. There are a few additional options and constraints while exposing this type of calculated member:

  • Dimension attribute can have an optional UnknownMember
  • An attribute containing calculated members cannot be the key attribute of the dimension, unless it is the only attribute of the dimension
  • An attribute containing calculated members cannot be a parent-child attribute

 

What am I missing ?

 

What does 'Multidimensional models expose calculated members on attribute hierarchies as values of a column.' mean ?  Am I looking in the wrong place ?

 

Sorry if silly questions, excuse the newbie.

1 REPLY 1
Anonymous
Not applicable

Hi @bjarvis100,

 

Based on test, power bi seems not support calculated members who contains multiple attributes or has hierarchy members.

Dimension Calculated Members (must be a single real member when the dimension has more than one attribute, it cannot be the key attribute of the dimension unless it is the only attribute, and it cannot be a parent-child attribute)

 

Maybe you can take a look at below link:

BUG Calculated member not appearing in the members list in tables or filters.

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors