topic Re: calculo complexo in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2860429#M92097 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="409111" data-lia-user-login="Victor1986" class="lia-mention lia-mention-user">Victor1986</a>&nbsp;</P> <P>&nbsp;</P> <P>Sorry I can't access your link. Can you represent the sample data in Excel, and the output you expect. The image of your original post cannot be enlarged, and the details cannot be seen clearly.</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Charlotte</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG>helps</STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><EM>Accept it as the solution</EM></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Tue, 25 Oct 2022 02:46:28 GMT v-zhangti 2022-10-25T02:46:28Z calculo complexo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2859093#M92009 <P><FONT>Bom dia!</FONT></P><P><FONT>Preciso calcular o resultado de saida de MUNICIPIO....</FONT></P><P><FONT>A regra é pegar a utltima DATA_UPDATE, maior ERB_FALHA por UF e retornar o municipio que teve maior registro de ERB_FALHA.</FONT></P><P><FONT>Segue link com os dados compartilhados&nbsp;<SPAN>&nbsp;</SPAN></FONT><A href="https://easyupload.io/sgt15f" target="_blank" rel="nofollow noopener noreferrer"><FONT>https://easyupload.io/k4h5gi</FONT></A></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 24 Oct 2022 12:09:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2859093#M92009 Victor1986 2022-10-24T12:09:14Z Re: calculo complexo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2860429#M92097 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="409111" data-lia-user-login="Victor1986" class="lia-mention lia-mention-user">Victor1986</a>&nbsp;</P> <P>&nbsp;</P> <P>Sorry I can't access your link. Can you represent the sample data in Excel, and the output you expect. The image of your original post cannot be enlarged, and the details cannot be seen clearly.</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Charlotte</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG>helps</STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><EM>Accept it as the solution</EM></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Tue, 25 Oct 2022 02:46:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2860429#M92097 v-zhangti 2022-10-25T02:46:28Z Re: calculo complexo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2861712#M92173 <P>Bom dia&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="332147" data-lia-user-login="v-zhangti" class="lia-mention lia-mention-user">v-zhangti</a>&nbsp;</P><P>&nbsp;</P><P>Segue atualização do link&nbsp;<A href="https://easyupload.io/p94rzb" target="_blank">https://easyupload.io/p94rzb</A></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 25 Oct 2022 12:16:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2861712#M92173 Victor1986 2022-10-25T12:16:40Z Re: calculo complexo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2862670#M92220 <P>Olá! Victor</P><P>&nbsp;</P><P>Fiz algumas medidas e cheguei a um resultado que seja o que procura.</P><P><img /></P><P>&nbsp;</P><P>Criei uma tabela exemplo no powerquery para conseguir fazer os calculos abaixo o layout do arquivo modelo.</P><P><img /></P><P>&nbsp;</P><P>Para chegar ao resultado eu utilizei duas medidas.</P><P>&nbsp;</P><P><img /><img /></P><P>&nbsp;</P> Tue, 25 Oct 2022 20:17:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2862670#M92220 elder_lops 2022-10-25T20:17:03Z Re: calculo complexo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2864870#M92302 <P>Bom dia&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="412176" data-lia-user-login="elder_lops" class="lia-mention lia-mention-user">elder_lops</a>&nbsp;</P><P>&nbsp;</P><P>Obrigado por tentar me ajudar mas...</P><P>O que preciso é trazer o resultado da cidade (top 1) que contem o maior numero de erbs falhas separado por UF ...por exemplo ....</P><P>AC temos varias cidades ...preciso trazer a cidade (top 1) que contempla maior numero de erbs falha....&nbsp;</P><P>AL tambem tem varias cidades ....preciso trazer a cidade que contempla maior quantidade de erbs falha ....</P><P>O resultado final é identificar as cidades (top 1) que precisam de maior atençaõ por terem maior numero de erbs falhas....</P> Wed, 26 Oct 2022 12:46:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2864870#M92302 Victor1986 2022-10-26T12:46:08Z Re: calculo complexo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2871347#M92658 <P>Bom dia! Vitor</P><P>Ok, mas no caso poderá haver cidades empatadas, quando houver essa situação o sistema deverá escolher uma ou apresentar as duas na lista.</P><P>&nbsp;</P> Fri, 28 Oct 2022 15:43:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/calculo-complexo/m-p/2871347#M92658 elder_lops 2022-10-28T15:43:07Z