topic Re: I don't want to show Maxx value on totals in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-don-t-want-to-show-Maxx-value-on-totals/m-p/3356530#M126141 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="256910" data-lia-user-login="felipereis50" class="lia-mention lia-mention-user">felipereis50</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">MAXX_Vendas = IF ( [TopN_Vendas] &lt;&gt; BLANK () &amp;&amp; HASONEVALUE ( fDados[SKU] ), MAXX ( fDados, [#vlr_unit_item] ) )</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 30 Jul 2023 04:07:42 GMT tamerj1 2023-07-30T04:07:42Z I don't want to show Maxx value on totals https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-don-t-want-to-show-Maxx-value-on-totals/m-p/3356430#M126137 <P>Hi friend,&nbsp;<BR />Anyone knows how to adjust this measure?<BR /><BR /></P><P><img /><BR /><BR />My first measure is<BR /><BR /></P><DIV><DIV><STRONG>TopN_Vendas = </STRONG></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[#vlr_contabil]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>TOPN</SPAN><SPAN>(7</SPAN><SPAN>,</SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>fDados</SPAN><SPAN>[DESCRICAO (#1)]</SPAN><SPAN>),</SPAN><SPAN>[#vlr_contabil]</SPAN><SPAN>)))</SPAN></DIV></DIV><P><BR /><BR />My MAXX measure is:<BR /><BR /></P><DIV><DIV><SPAN><STRONG>MAXX_Vendas</STRONG> = </SPAN></DIV><DIV><DIV><DIV><SPAN>var</SPAN> <SPAN>maxx_var</SPAN><SPAN> = </SPAN><SPAN>MAXX</SPAN><SPAN>(</SPAN><SPAN>fDados</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[#vlr_unit_item]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>[TopN_Vendas]</SPAN><SPAN> = </SPAN><SPAN>BLANK</SPAN><SPAN>(), </SPAN><SPAN>BLANK</SPAN><SPAN>(), </SPAN><SPAN>maxx_var</SPAN><SPAN>)</SPAN></DIV></DIV></DIV></DIV><P><BR /><BR /></P> Sat, 29 Jul 2023 14:32:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-don-t-want-to-show-Maxx-value-on-totals/m-p/3356430#M126137 felipereis50 2023-07-29T14:32:46Z Re: I don't want to show Maxx value on totals https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-don-t-want-to-show-Maxx-value-on-totals/m-p/3356530#M126141 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="256910" data-lia-user-login="felipereis50" class="lia-mention lia-mention-user">felipereis50</a>&nbsp;<BR />Please try</P> <LI-CODE lang="javascript">MAXX_Vendas = IF ( [TopN_Vendas] &lt;&gt; BLANK () &amp;&amp; HASONEVALUE ( fDados[SKU] ), MAXX ( fDados, [#vlr_unit_item] ) )</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 30 Jul 2023 04:07:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-don-t-want-to-show-Maxx-value-on-totals/m-p/3356530#M126141 tamerj1 2023-07-30T04:07:42Z