Optimizing performance: Tables or measures?

AnonymousThank you for the suggestions and the link. I did have a look at it and will try to work my way through it.

MattAllingtonSorry, yes, I meant the render time.

This is the matrix:

Takes 8 - 10 seconds to render

I have tried breaking down the matrix into 9 individual visuals, each visual with a single measure for testing purposes. Keeping the original matrix on the same page (8 or 9 seconds to render), the indivual matrices all take under 3 seconds (with the exception of one (last column on the right) which takes 5 seconds to render. These are the measures in the measure (column) with the poorest performance:

Render approx 5 seconds

And here are two of the more complex columns and measures:

Render approx 2 secondsrender approx 1 second

What I find surprising is that individually these 9 measures render in under 3 seconds, (except for 1, which takes approx 5 seconds) and the complete matrix, which is on the same page as the individual measures (for testing purposes: the real page report only contains the complete matrix.), takes approximately 8 or 9 seconds.

Thank you for any further ideas.

Regards,

Paul.