I have a measure for "+5%" scaling of Y-axis.
Measure_MaxY =
MAXX(
SUMMARIZE(FactTable, DimCalendar[Ultimo], "Max Measure", [Measure])
, [Max Measure]
) * 1.05
I need to amend the measure so that it doesn't scale for total of Measure, but for a subtotal according to Currency dimension. (A line chart with Currency_Cluster in Legend).
The following somewhat works:
Measure_MaxY2 = MAXX(
SUMMARIZE(
FactTable,
DimCalendar[Ultimo],
"currency_cluster",
MAX('DimCurrency'[currency_cluster]),
"Max Measure",
[Measure]
),
[Max Measure]
) * 1.05
meaning the syntax is not incorrect, but it seems to return higher value than what I expect, so sometimes the scaling looks "+5%" as expected, but perhaps most of the time, it is "+20%" or so. Any ideas where the problem might be? Thanks.
