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.
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:
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.
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: