topic Total Distinct Sum of a measure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145193#M112487 <P>Olá amigos, preciso de uma ajuda com total distinto de uma medida.</P><P>&nbsp;</P><P>Abaixo está a tabela</P><P>coluna1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Coluna2</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30</P><P>D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P><P>&nbsp;</P><P><SPAN>A saída desejada seria 80, pois A repete e de só deve ser considerado uma vez</SPAN></P><P>&nbsp;</P><P><SPAN>Como posso realizar essa soma distinta?</SPAN></P><P>&nbsp;</P><P><SPAN>This is the measurement I'm currently using</SPAN></P><DIV><PRE><SPAN>RevAnt = </SPAN><BR /><BR /><SPAN>&nbsp;</SPAN><FONT><SPAN>var</SPAN><SPAN> risco = [RiscoSacadoGroup] </SPAN></FONT><BR /><BR /><SPAN>&nbsp;</SPAN><FONT><SPAN>var</SPAN><SPAN> ref = </SPAN><SPAN>CALCULATE</SPAN>(<SPAN>SUM</SPAN>(Estoque[%Referencia]),<SPAN>GROUPBY</SPAN><SPAN>(Estoque,Estoque[DOC_SACADO_Raiz])) </SPAN></FONT><BR /><BR /><SPAN>&nbsp;</SPAN><SPAN>retornar</SPAN><BR /><BR /><SPAN>ref * risco</SPAN></PRE></DIV><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><SPAN>this is my table</SPAN></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 21 Mar 2023 16:07:30 GMT Anonymous 2023-03-21T16:07:30Z Total Distinct Sum of a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145193#M112487 <P>Olá amigos, preciso de uma ajuda com total distinto de uma medida.</P><P>&nbsp;</P><P>Abaixo está a tabela</P><P>coluna1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Coluna2</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10</P><P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30</P><P>D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P><P>&nbsp;</P><P><SPAN>A saída desejada seria 80, pois A repete e de só deve ser considerado uma vez</SPAN></P><P>&nbsp;</P><P><SPAN>Como posso realizar essa soma distinta?</SPAN></P><P>&nbsp;</P><P><SPAN>This is the measurement I'm currently using</SPAN></P><DIV><PRE><SPAN>RevAnt = </SPAN><BR /><BR /><SPAN>&nbsp;</SPAN><FONT><SPAN>var</SPAN><SPAN> risco = [RiscoSacadoGroup] </SPAN></FONT><BR /><BR /><SPAN>&nbsp;</SPAN><FONT><SPAN>var</SPAN><SPAN> ref = </SPAN><SPAN>CALCULATE</SPAN>(<SPAN>SUM</SPAN>(Estoque[%Referencia]),<SPAN>GROUPBY</SPAN><SPAN>(Estoque,Estoque[DOC_SACADO_Raiz])) </SPAN></FONT><BR /><BR /><SPAN>&nbsp;</SPAN><SPAN>retornar</SPAN><BR /><BR /><SPAN>ref * risco</SPAN></PRE></DIV><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><SPAN>this is my table</SPAN></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 21 Mar 2023 16:07:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145193#M112487 Anonymous 2023-03-21T16:07:30Z Re: Total Distinct Sum of a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145362#M112495 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>please try</P> <P>RevAnt =<BR />SUMX (<BR />SUMMARIZE (<BR />Estoque,<BR />Estoque[DOC_SACADO_Raiz],<BR />"Referencia", MAX ( Estoque[%Referencia] )<BR />),<BR />[Referencia]<BR />) * [RiscoSacadoGroup]</P> Tue, 21 Mar 2023 17:12:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145362#M112495 tamerj1 2023-03-21T17:12:48Z Re: Total Distinct Sum of a measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145371#M112497 <P><SPAN class=""><SPAN class="">Muito Obrigado!</SPAN></SPAN> <SPAN class=""><SPAN class="">Deu tudo certo!</SPAN></SPAN></P> Tue, 21 Mar 2023 17:18:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Total-Distinct-Sum-of-a-measure/m-p/3145371#M112497 Anonymous 2023-03-21T17:18:15Z