Dynamically calculated Y axis maximum (extra space over max displayed value)

[Petr_M]

I have a measure.

Ratio = sum(Table[A])/sum(Table[B])

I want to plot the Ratio in a chart that has an Y axis with the following idea:

MaxY = max(Ratio)*1.3

so that the maximum value has extra space obove regardless any slicers applied.

Seems simple but I was unable to find the solution so far.

Thanks a lot!

[amitchandak · Accepted solution]

@Petr_M , Using the column used on x-axis

MaxY = maxX(Values(Table[Col]) ,[Ratio])*1.3

[Petr_M]

If I may have one more question, @amitchandak , is it possible to also modify the formula so that it looks at A instead of Ratio? If simply replaced like this:

MaxY = maxX(Values(DimCalendar[Ultimo]) ,Table[A])*1.3

I get an error message: "A single value for column 'A' in table 'Table' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

I tried to fix it by adding a sum, but it seems to sum also over all ultimo values.

Thanks.

[Petr_M]

Works like a charm! Thanks a lot, @amitchandak!