Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there,
I have a problem browsing calculated measure with parent-child dimension.
I am using AdventureWorks (OLAP 2014)
Here is a calculated measure definition:
CREATE MEMBER CURRENTCUBE.[Measures].[Sales Quota JustItSelf]
AS ([Employee].[Employees].CurrentMember.DataMEMBER,[Measures].[Sales Amount Quota]),
FORMAT_STRING = "Currency",
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP = 'Sales Targets' ;
Here what I see on the EmloyeeLeve05 browsing that measure in PowerBI:
If I brows it in Excel it doesn't bring parent with children:
How to get same behaviour in PowerBI?
Is it a bug or I need some settings to change?
Please help.
Thank you.
You need to select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.
Unfortunately it didn't work (see the picture):
Any other ideas?
Thank you,
Michael
In the Format section of the Visualizations pane, expand the Subtotals card, turn the Row subtotals slider to On.
Thank you for reply,
Unfortunately it didn't solve the problem.
Thanks again,
Michael
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
91 | |
86 | |
76 | |
66 |
User | Count |
---|---|
148 | |
115 | |
110 | |
102 | |
95 |