https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-MAX-and-filter-context/m-p/4211884#M166992 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="749867" data-lia-user-login="gumis_rulez" class="lia-mention lia-mention-user">gumis_rulez</a> is this your desired outcome?</P><P><img /></P><P>&nbsp;</P> Wed, 02 Oct 2024 11:25:28 GMT DimaMD 2024-10-02T11:25:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-MAX-and-filter-context/m-p/4211775#M166987 <P>How to properly calculate MAX Net Revenue for Each agent in all years? I am using following measure:</P><P>&nbsp;</P><LI-CODE lang="markup">Max Test = MAXX( ALLEXCEPT(dim_Calendar, dim_Calendar[Year]), [Net Revenue] )</LI-CODE><P>But it seams is not working properly. For Adam Metcalfe for each year, value should be 25 963.</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><A href="https://drive.google.com/file/d/1R3QwcUbAH9ep24L14gjmOeux4ClgU56z/view?usp=sharing" target="_self">https://drive.google.com/file/d/1R3QwcUbAH9ep24L14gjmOeux4ClgU56z/view?usp=sharing</A>&nbsp;</P> Wed, 02 Oct 2024 10:18:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-MAX-and-filter-context/m-p/4211775#M166987 gumis_rulez 2024-10-02T10:18:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-MAX-and-filter-context/m-p/4211884#M166992 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="749867" data-lia-user-login="gumis_rulez" class="lia-mention lia-mention-user">gumis_rulez</a> is this your desired outcome?</P><P><img /></P><P>&nbsp;</P> Wed, 02 Oct 2024 11:25:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-MAX-and-filter-context/m-p/4211884#M166992 DimaMD 2024-10-02T11:25:28Z