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