SSAS calculated measure shown incorrect with Parent-child dimension

[MKTorn]

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.

[v-chuncz-msft]

@MKTorn,

You need to select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.

[MKTorn]

Unfortunately it didn't work (see the picture):

Any other ideas?

Thank you,

Michael

[v-chuncz-msft]

@MKTorn,

In the Format section of the Visualizations pane, expand the Subtotals card, turn the Row subtotals slider to On.

[MKTorn]

Thank you for reply,

Unfortunately it didn't solve the problem.

Thanks again,

Michael