topic Re: Need Help with MAXX in DAX Commands and Tips

Need Help with MAXX

DAXHeadroom — Wed, 07 Feb 2024 19:32:18 GMT

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]

)

Re: Need Help with MAXX

Jihwan_Kim — Wed, 07 Feb 2024 21:11:55 GMT

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] )

Re: Need Help with MAXX

DAXHeadroom — Thu, 08 Feb 2024 13:42:44 GMT

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

Re: Need Help with MAXX

Anonymous — Wed, 21 Feb 2024 08:51:28 GMT

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.