Forum Discussion
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 ...
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 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 |