Set Analysis: Maximum of a value over two dimensions

[#1]

Hi,

I have the following problem. I want to compare different values based on two different selections.

Both my bar charts have two dimensions: year and month

I want that both bar charts have the same scale, depending on the highest maximum of the selected month. E.g. In the pic you see June as the highest month. This should be the maximum value of my static scale.

So far I reached the following solution:

=if(sum({[CompareLeft]<[FilterArg] = {'ABC'}>} [Metric]) >= sum({[CompareRight] <[FilterArg] = {'ABC'}>} [Metric]),

    sum({[CompareLeft]<[FilterArg] = {'ABC'}>} [Metric])+200,

    sum({[CompareRight] <[FilterArg] = {'ABC'}>} [Metric])+200)

The problem here is, it summarizes all the timeframe and not just one month. Using Max instead of sum doesnt help neither. Do you have any ideas?

[Gysbert_Wassenaar · Accepted solution]

=rangemax(max(aggr(sum({[CompareLeft]<[FilterArg] = {'ABC'}>} [Metric]),Month)) , max(aggr(sum({[CompareRight] <[FilterArg] = {'ABC'}>} [Metric]),Month)) )

[#3]

Magic, Thanks Gysbert!