Forum Discussion

DAXHeadroom's avatar
DAXHeadroom
Frequent Visitor
2 years ago
Solved

Need Help with MAXX

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 ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

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