Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I used to have multidimensional SSAS cube where I have parent-child hierarchy and aggregations of children members should be substituted with value for parent coming from source system. For these purposes I use MDX expressions:
SCOPE(MeasureGroupMeasures("MeasureGroup"))
THIS = [Dim].[Hierarchy].CURRENTMEMBER.DATAMEMBER
END SCOPE
I'd like to replicate the cube as tabular mode but I am having difficulties with the expression in DAX instead of SCOPE expression in MDX.
Basically, I have children A= 5, B = 3, C = 7 and by default they will be summarized for parent as D = A + B + C = 15.
I need to have a value from source system for parent instead of aggregation as D = 12 for example.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
41 | |
36 | |
22 | |
21 | |
20 |