Need Help with MAXX

[DAXHeadroom]

The following measure yeilds the maximum Planned Capacity for all years rather than my intended maximum Planned Capacity for a given / single year. For example, the maximum Planned Capacity for 2023 = 28 and the maximum Planned Capacity for 2024 = 26.  This measure always yeilds 28. Can someone help with what I am doing wrong? Thanks. 

Planned Capacity Measure = MAXX(

    SUMMARIZE('Planned Capacity Table','Planned Capacity Table'[Year],

"MAXCapacity",

    MAX('Planned Capacity Table'[Planned Capacity])),

    [MAXCapacity]

)

[v-yangliu-msft · Accepted solution]

Hi  @DAXHeadroom ,

You can try the following dax：

Planned Capacity Measure =
MAXX(
    FILTER(ALLSELECTED('Planned Capacity Table'),
    'Planned Capacity Table'[Year]=MAX('Table'[Year])),[Planned Capacity])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DAXHeadroom]

@Jihwan_Kim Thank you for the reply. Unfortunatley, this measure yeilds the same result (28 in the example above). 

Below is an example of my table. 

The table is related to a Date Table (Weekday to Weekday) and I have Year, Month and Weekday Slicers based on the Date Table. Regardless of selection (or deselection) of any/all Slicers, the result is always 28. 

Any help is appreciated. 

Base	Weekday	Planned Capacity	Weekday Number	Month	Year
ABC	Tuesday	28	3	January	2023
ABC	Tuesday	26	3	January	2024

[Jihwan_Kim]

Hi,

Please try something like below whether it suits your requirement.

Planned Capacity Measure =
MAXX (
    ADDCOLUMNS (
        SUMMARIZE ( 'Planned Capacity Table', 'Planned Capacity Table'[Year] ),
        "MAXCapacity", CALCULATE ( MAX ( 'Planned Capacity Table'[Planned Capacity] ) )
    ),
    [MAXCapacity]
)