topic Re: My own Total grupo in DAX Commands and Tips

topic Re: My own Total grupo in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3918745#M152537 <P>I can't locate the problem by just looking at the screenshot, can you provide the pbix file or some sample data?</P> Wed, 15 May 2024 01:40:52 GMT xifeng_L 2024-05-15T01:40:52Z My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917552#M152484 <P>I need help calculating the total percentage per group and the expiration per group, keeping in mind that each line in the group is a different measure <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span><BR /><BR />Example:<BR /><BR /></P><P><img /></P><P> </P> Tue, 14 May 2024 13:45:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917552#M152484 Amircal 2024-05-14T13:45:31Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917613#M152488 <P>Can provide some sample data or pbix? And what is the calculate logic?</P> Tue, 14 May 2024 14:14:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917613#M152488 xifeng_L 2024-05-14T14:14:53Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917693#M152491 <P>Hi, <BR /><BR />This is the measure for Vencimiento:</P><DIV>Test:=</DIV><DIV> </DIV><DIV>VAR _Empresa=SELECTEDVALUE(DimEmpresas[IdEmpresa])</DIV><DIV>VAR _Grupo=SELECTEDVALUE(Antiguedadcxc[BusinessPartnerGroupName])</DIV><DIV>VAR _currentAgingBucket=MAX(OrdenVencimiento[AgingBucket])</DIV><DIV> </DIV><DIV>VAR SelectedAgingBucket=</DIV><DIV>    SWITCH(TRUE(),</DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=1, CALCULATE([MedidaFiltrosVencido], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=2, CALCULATE([MedidaFiltrosAbonosFuturos], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)), </SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=3, CALCULATE([TotalCarteraGroup], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=4, CALCULATE([MedidaFiltros0-30], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=5, CALCULATE([MedidaFiltros31-60], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=6, CALCULATE([MedidaFiltros61-90], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=7, CALCULATE([MedidaFiltros91-120], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=8, CALCULATE([MedidaFiltros>120],  CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(Antiguedadcxc[BusinessPartnerGroupName])=_Grupo, [TotalCarteraGroup],</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(Antiguedadcxc[IdEmpresa])=_Empresa, [TotalCarteraEmpresa],[TotalCartera])</SPAN></DIV><DIV> </DIV><DIV>return IF(ISBLANK(SelectedAgingBucket),0,SelectedAgingBucket)<BR /><BR /><BR />I need to know when is the<P><BR />This is the measure for Vencimiento:</P><DIV>Test:=</DIV><DIV> </DIV><DIV>VAR _Empresa=SELECTEDVALUE(DimEmpresas[IdEmpresa])</DIV><DIV>VAR _Grupo=SELECTEDVALUE(Antiguedadcxc[BusinessPartnerGroupName])</DIV><DIV>VAR _currentAgingBucket=MAX(OrdenVencimiento[AgingBucket])</DIV><DIV> </DIV><DIV>VAR SelectedAgingBucket=</DIV><DIV>    SWITCH(TRUE(),</DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=1, CALCULATE([MedidaFiltrosVencido], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=2, CALCULATE([MedidaFiltrosAbonosFuturos], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)), </SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=3, CALCULATE([TotalCarteraGroup], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=4, CALCULATE([MedidaFiltros0-30], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=5, CALCULATE([MedidaFiltros31-60], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=6, CALCULATE([MedidaFiltros61-90], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=7, CALCULATE([MedidaFiltros91-120], CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV><DIV><SPAN>SELECTEDVALUE(OrdenVencimiento[AgingOrder])=8, CALCULATE([MedidaFiltros>120],  CROSSFILTER( OrdenVencimiento[AgingBucket], Antiguedadcxc[AgingBucket],Both)),</SPAN></DIV></DIV><P><BR /><BR />I thinks i have the issue cause i have the "Total General " at the same level has the groups clients but the clients dont have a Group Name Total General <BR /><BR /></P> Tue, 14 May 2024 14:57:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917693#M152491 Amircal 2024-05-14T14:57:48Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917732#M152493 <P>I need to identify when the selectedrow IT's "Total General"</P> Tue, 14 May 2024 15:04:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917732#M152493 Amircal 2024-05-14T15:04:40Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917791#M152498 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="742758" data-lia-user-login="Amircal" class="lia-mention lia-mention-user">Amircal</a> ,</P><P> </P><P>You can rewrite the rest like the boxed part in the image below.</P><P> </P><P><img /></P><P> </P><P> </P><P>Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !</P><P> </P><P>Thank you~</P> Tue, 14 May 2024 15:23:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3917791#M152498 xifeng_L 2024-05-14T15:23:56Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3918258#M152516 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="738384" data-lia-user-login="xifeng_L" class="lia-mention lia-mention-user">xifeng_L</a> <BR /><BR />The problem i have its the selectedvalue for the Total General its Blank, when the ralation dont have data.<BR /><BR /><BR /></P><P>Test3:=<BR />VAR _Empresa=SELECTEDVALUE(DimEmpresas[IdEmpresa])<BR />VAR _Grupo=SELECTEDVALUE(Antiguedadcxc[BusinessPartnerGroupName])<BR />VAR _currentAgingBucket=MAX(OrdenVencimiento[AgingBucket])</P><P>VAR SelectedAgingBucket= _grupo</P><P>return SelectedAgingBucket<BR /><BR /></P><P><img /></P><P>I dont know how to explain that :(, i do a relationships 1 to both tables</P> Tue, 14 May 2024 18:43:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3918258#M152516 Amircal 2024-05-14T18:43:20Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3918745#M152537 <P>I can't locate the problem by just looking at the screenshot, can you provide the pbix file or some sample data?</P> Wed, 15 May 2024 01:40:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3918745#M152537 xifeng_L 2024-05-15T01:40:52Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3924375#M152700 <P>Solved.</P> Thu, 16 May 2024 13:58:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3924375#M152700 Amircal 2024-05-16T13:58:33Z Re: My own Total grupo https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3938095#M153149 <P>Hi, <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="742758" data-lia-user-login="Amircal" class="lia-mention lia-mention-user">Amircal</a> <BR /><BR />Thanks for <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="738384" data-lia-user-login="xifeng_L" class="lia-mention lia-mention-user">xifeng_L</a> reply. I'm glad you were able to solve the problem. Could you please be able to share your solution to help more people with similar problems refer to your solution, thank you very much.<BR /><BR /></P> <P>Best Regards,<BR />Yang<BR />Community Support Team</P> Wed, 22 May 2024 05:56:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/My-own-Total-grupo/m-p/3938095#M153149 Anonymous 2024-05-22T05:56:50Z