Measure for scaling Y-axis with Measure acc. to Currency

PetrM — Thu, 02 Mar 2023 11:59:29 GMT

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.

Re: Measure for scaling Y-axis with Measure acc. to Currency

lbendlin — Sat, 04 Mar 2023 01:31:31 GMT

use EVALUATEANDLOG and DAX Debug Output to look into the MAXX array to see which values may be unexpected.

topic Measure for scaling Y-axis with Measure acc. to Currency in DAX Commands and Tips

Measure for scaling Y-axis with Measure acc. to Currency

Re: Measure for scaling Y-axis with Measure acc. to Currency