SSAS Measure -> Retrive the selected value from Measure

Savitri Biju 1 Reputation point
2021-02-26T16:56:02.643+00:00

Hi, I have a hierarchy HL1 HL21 HL211 HL212 HL22 HL221 Users access this cube data in Excel. They place this hierarchy in the COLUMNS section of pivot. The result should be as below in the image. ![72489-capture.png][1] [1]: /api/attachments/72489-capture.png?platform=QnA Basically when the user selects HL21 in the hierarchy and is at that level, it should show the balance for HL21 i.e. 600$ However when the the user drills down to the next level -> excel displays HL211, HL212, HL213 -> the new measure should still show the balance of HL21 -> $600 Please help.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-01T09:52:02.593+00:00

    This should be a MDX issue for SSAS multidimensional cube ?