topic Re: Distinc sum group by multı colum in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760259#M85526 <P>Thank You So Much.</P><P>&nbsp;</P> Sun, 11 Sep 2022 10:56:49 GMT DRNEWTR 2022-09-11T10:56:49Z Distinc sum group by multı colum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760169#M85521 <P>Hi,</P><P>I need sum distinc by group</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sun, 11 Sep 2022 09:34:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760169#M85521 DRNEWTR 2022-09-11T09:34:30Z Re: Distinc sum group by multı colum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760225#M85524 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="384889" data-lia-user-login="DRNEWTR" class="lia-mention lia-mention-user">DRNEWTR</a>&nbsp;Try:</P> <LI-CODE lang="markup">Measure = VAR __Table = DISTINCT( SELECTCOLUMNS('DATA',"STORE",[STORE],"ORDER NUMBER",[ORDERNUMBER],"PERSON",[PERSON]) ) RETURN SUMX(__Table,[PERSON])</LI-CODE> Sun, 11 Sep 2022 10:40:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760225#M85524 Greg_Deckler 2022-09-11T10:40:02Z Re: Distinc sum group by multı colum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760259#M85526 <P>Thank You So Much.</P><P>&nbsp;</P> Sun, 11 Sep 2022 10:56:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distinc-sum-group-by-mult%C4%B1-colum/m-p/2760259#M85526 DRNEWTR 2022-09-11T10:56:49Z