Tag Archives: mdx percentage of total ssrs

Analysis Services, Models

MDX : Percentage of Total and SSRS

Leave a comment

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]