SSRS Max Row Value across all columns

Question

I'm busy with a report to show maximum value for a group, however when I do a MAX function I only get the the same result as the current row and I require it to be the same/highest MAX value in all rows. I need to do this on the report itself as the data set is MDX.

As you can see below, I require the max column to be 67% on all the rows.

Report Screenshot

It's not clear how you are calculating the percentage. Have you tried an expression in this form: =Max(Fields!ColA.Value / Fields!ColB.Value) ? — StevenWhite
Hi. The percentages come from a data warehouse. However, I don't really care if it's percentages or just normal amounts, I'm not able to get the highest max amount to show in all columns. — DerikPelser

Alan Schofield Alan Schofield · Accepted Answer · 2018-01-03T11:04:02

You need to include the scope in your expression, something like

=Max(Fields!ColA.Value / Fields!ColB.Value, "myDataSetName")

or

=Max(Fields!ColA.Value / Fields!ColB.Value, "myColumnGroupName")

Without seeing the full design I can't tell you what it should be but the first option above would give you the max amount over the entire dataset and the second example would show calcuate this within the columngroup.

SSRS Max Row Value across all columns

1 Answers