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 = 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]
)
  • 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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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]
)
  • DAXHeadroom's avatar
    DAXHeadroom
    Frequent Visitor
    2 years ago

    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. 

     

    BaseWeekdayPlanned CapacityWeekday NumberMonthYear
    ABCTuesday283January2023
    ABCTuesday263January2024