How to get max value of two colums?

[PowerRon]

Hi,

This is my bar chart.
In the legend the 'Year' (column of Date table), the Y-axis 'Region' (column of Country table), the X-axis 'Sum Quantity'
The bar overlaps sometimes the labels. To prevent that I want to compute a MAX value and compute it with 1.2
This computed measure I will then put in X-axis / Range / Maximum

If I wouldn't have a legend, the next measure would work

_Max X = MAXX(VALUES('Regions'[Domestic]),[Sum Quantity]) * 1.2

But if I use this measure with the legend, this happens



_Max X becomes (35K + 35K + 16K) * 1.2
But it should become 35K (being the highest value for a single bar) * 1.2

Of course I have to embed the legend (Year) as well in my measure.
How do I do that?

Regards
Ron

[bhanu_gautam · Accepted solution]

@PowerRon , Try using

DAX
_Max X =
MAXX(
SUMMARIZE(
'YourTable',
'Date'[Year],
'Country'[Region],
"SumQuantity", [Sum Quantity]
),
[SumQuantity]
) * 1.2

[PowerRon]

Thnx @bhanu_gautam , it works