Zahid's blog on Data Engineering and BI

A showcase of my experience in technologies like SQL, SSIS, SSAS, ETL, Azure, Power BI, DAX etc..

Market Share Calculation in MDX based on AXIS

Posted on March 1, 2011March 1, 2011 by Zahid

Below is the MDX which will calculate market share at runtime/dynamically. It always reads data from the parent axis.

iif
(
  Axis(1)(0)(Axis(1)(0).Count – 1).Dimension.CurrentMember.Parent is null,
  null,
(
     [measures].[x]
     /
     (
    [measures].[x],Axis(1)(0)(Axis(1)(0).Count -1).Dimension.CurrentMember.Parent
   )
  )

  * 100
)

2 thoughts on “Market Share Calculation in MDX based on AXIS”

Daniel José da Silva says:

January 31, 2013 at 7:50 pm

Very nice but I have other problem.
How I can show the Grand Total with sum of Market Share?

Reply
Zahid says:

March 17, 2013 at 11:53 am

Did u try writing a SCOPE for ‘ALL’ member of your parent dimension. You can sum over the Market Share calculated measure inside that SCOPE.

Reply