MDX : Percentage of Total and SSRS

A simple Percentage of Total Calculation example. If you are bringing your MDX dataset into SSRS remember SSRS doesn’t recognise MDX percentage values formatted with FORMAT_STRING=”Percent” – so you’ll need to specify the percentage format in your SSRS chart or tablix.

MEMBER Measures.PercentageOfTotal
as 
 [Measures].[Your Measure Count] / Sum( Axis(1), [Measures].[Your Measure Count])
 ,FORMAT_STRING="Percent"

SELECT {
[Measures].[Your Measure Count],
[Measures].[PercentageOfTotal]
} ON COLUMNS, 

{[Date].[Month].[Month].Members}
ON ROWS
 
FROM [Wruggles_Cube] 

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s