SSAS Measure -> Retrive the selected value from Measure

Savitri Biju 1 Reputation point

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,256 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points

    This should be a MDX issue for SSAS multidimensional cube ?