Maximum value of Y-axis of small multiple

[Anonymous]

Hi,

Can the maximum value of the Y-axis of a small multiple be the maximum value of the values of the selected cells?

The Y axis does not change dynamically even if DAX below is set to the maximum value.

maxvalue =

MAXX(

    KEEPFILTERS(VALUES('Category'[ctg])),

    CALCULATE(

        MAXX(

            KEEPFILTERS(VALUES('calendar'[YYYYMM])),

            CALCULATE(sum(Fact[value]))

        )

        ,ALLSELECTED('calendar'[YYYYMM])

    )

)

[amitchandak · Accepted solution]

@Anonymous , Try like

maxvalue =
CALCULATE(MAXX(
Summarize(Fact, 'Category'[ctg], 'calendar'[YYYYMM] , "_1" ,CALCULATE(sum(Fact[value]))), [_1])
,ALLSELECTED('calendar'[YYYYMM])
)