topic Re: Dax Formula Help - For given columns and filter value SUM another column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3515118#M134931 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="640673" data-lia-user-login="FahadQ" class="lia-mention lia-mention-user">FahadQ</a>&nbsp;, try this measure:&nbsp;</P> <LI-CODE lang="markup">_VarGroup = CALCULATE( SUM( data[VarGroup] ), data[Status] = "Active" )</LI-CODE> Fri, 03 Nov 2023 18:57:55 GMT ERD 2023-11-03T18:57:55Z Dax Formula Help - For given columns and filter value SUM another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3514723#M134915 <P>I have inputted the data set below and power bi report layout I would like to acheive</P><P>&nbsp;</P><P>Basically I need to know the DAX formula for&nbsp;</P><P>&nbsp;</P><P>SUM (VarGroup) for given PolicyNumber, WS Instance, penedid,Coverage Date, where status = Active</P><P>&nbsp;</P><P><STRONG>Report</STRONG></P><TABLE><TBODY><TR><TD>PolicyNumber</TD><TD>Cov Eff Date</TD><TD>Auto Added</TD><TD>Endorsement Code</TD><TD>Endorsement Title</TD><TD>Endorsement Effective Date</TD><TD>Cancel Date</TD><TD>Endorsement Expiry Date</TD><TD>Signature Required</TD><TD>Signed by Policyholder</TD><TD>VarGroup</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2017</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2016</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2015</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2014</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>5</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2014</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2014</TD><TD>June 30, 2015</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2013</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2010</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>GE 1 36131</TD><TD>September 1, 2012</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2010</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P><STRONG>Data</STRONG></P><TABLE><TBODY><TR><TD>PolicyNumber</TD><TD>Auto Added</TD><TD>Endorsement Code</TD><TD>Endorsement Title</TD><TD>Endorsement Effective Date</TD><TD>Cancel Date</TD><TD>Cov Eff Date</TD><TD>Endorsement Expiry Date</TD><TD>Signature Required</TD><TD>Signed by Policyholder</TD><TD>Name</TD><TD>Values</TD><TD>WS Instance</TD><TD>Pen ENDID</TD><TD>Status</TD><TD>Detail ID</TD><TD>Variable ID</TD><TD>VarGroup</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tokyo</TD><TD>851110</TD><TD>4902931</TD><TD>Active</TD><TD>3183723</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>851110</TD><TD>4902931</TD><TD>Active</TD><TD>3183721</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Towa</TD><TD>851110</TD><TD>4902931</TD><TD>Active</TD><TD>3183722</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Hanwa</TD><TD>851110</TD><TD>4902931</TD><TD>Active</TD><TD>3183724</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Jap</TD><TD>851110</TD><TD>4902931</TD><TD>Active</TD><TD>3183725</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2014</TD><TD>June 30, 2015</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Hanwa</TD><TD>851110</TD><TD>4902930</TD><TD>Cancelled</TD><TD>3183718</TD><TD>1187</TD><TD>&nbsp;</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2014</TD><TD>June 30, 2015</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Towa</TD><TD>851110</TD><TD>4902930</TD><TD>Cancelled</TD><TD>3183716</TD><TD>1187</TD><TD>&nbsp;</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2014</TD><TD>June 30, 2015</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>851110</TD><TD>4902930</TD><TD>Cancelled</TD><TD>3183715</TD><TD>1187</TD><TD>&nbsp;</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2014</TD><TD>June 30, 2015</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Jap</TD><TD>851110</TD><TD>4902930</TD><TD>Cancelled</TD><TD>3183719</TD><TD>1187</TD><TD>&nbsp;</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2014</TD><TD>June 30, 2015</TD><TD>September 1, 2014</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tokyo</TD><TD>851110</TD><TD>4902930</TD><TD>Cancelled</TD><TD>3183717</TD><TD>1187</TD><TD>&nbsp;</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2017</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Jap</TD><TD>100028</TD><TD>6570804</TD><TD>Active</TD><TD>4492710</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2017</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>100028</TD><TD>6570804</TD><TD>Active</TD><TD>4492706</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2017</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Towa</TD><TD>100028</TD><TD>6570804</TD><TD>Active</TD><TD>4492707</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2017</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tokyo</TD><TD>100028</TD><TD>6570804</TD><TD>Active</TD><TD>4492708</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2017</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Hanwa</TD><TD>100028</TD><TD>6570804</TD><TD>Active</TD><TD>4492709</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2010</TD><TD>&nbsp;</TD><TD>September 1, 2013</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>765825</TD><TD>4014096</TD><TD>Active</TD><TD>2558828</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2010</TD><TD>&nbsp;</TD><TD>September 1, 2013</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>towa</TD><TD>765825</TD><TD>4014096</TD><TD>Active</TD><TD>2558829</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2016</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Hanwa</TD><TD>995382</TD><TD>6510535</TD><TD>Active</TD><TD>4445863</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2016</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>995382</TD><TD>6510535</TD><TD>Active</TD><TD>4445860</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2016</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tokyo</TD><TD>995382</TD><TD>6510535</TD><TD>Active</TD><TD>4445862</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2016</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Towa</TD><TD>995382</TD><TD>6510535</TD><TD>Active</TD><TD>4445861</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2016</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Jap</TD><TD>995382</TD><TD>6510535</TD><TD>Active</TD><TD>4445864</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2015</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tokyo</TD><TD>908778</TD><TD>5507017</TD><TD>Active</TD><TD>3664358</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2015</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>908778</TD><TD>5507017</TD><TD>Active</TD><TD>3664356</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2015</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Towa</TD><TD>908778</TD><TD>5507017</TD><TD>Active</TD><TD>3664357</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2015</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Hanwa</TD><TD>908778</TD><TD>5507017</TD><TD>Active</TD><TD>3664359</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>July 1, 2015</TD><TD>&nbsp;</TD><TD>September 1, 2015</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>jap</TD><TD>908778</TD><TD>5507017</TD><TD>Active</TD><TD>3664360</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2010</TD><TD>&nbsp;</TD><TD>September 1, 2012</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>Tsuk</TD><TD>697648</TD><TD>3354307</TD><TD>Active</TD><TD>2111839</TD><TD>1187</TD><TD>1</TD></TR><TR><TD>GE 1 36131</TD><TD>No</TD><TD>SC001</TD><TD>Exclusion</TD><TD>September 1, 2010</TD><TD>&nbsp;</TD><TD>September 1, 2012</TD><TD>&nbsp;</TD><TD>No</TD><TD>&nbsp;</TD><TD>Excluded from ABC</TD><TD>towa</TD><TD>697648</TD><TD>3354307</TD><TD>Active</TD><TD>2111840</TD><TD>1187</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P> Fri, 03 Nov 2023 15:14:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3514723#M134915 FahadQ 2023-11-03T15:14:10Z Re: Dax Formula Help - For given columns and filter value SUM another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3515118#M134931 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="640673" data-lia-user-login="FahadQ" class="lia-mention lia-mention-user">FahadQ</a>&nbsp;, try this measure:&nbsp;</P> <LI-CODE lang="markup">_VarGroup = CALCULATE( SUM( data[VarGroup] ), data[Status] = "Active" )</LI-CODE> Fri, 03 Nov 2023 18:57:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3515118#M134931 ERD 2023-11-03T18:57:55Z Re: Dax Formula Help - For given columns and filter value SUM another column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3519229#M135167 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="640673" data-lia-user-login="FahadQ" class="lia-mention lia-mention-user">FahadQ</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">If these also don't help, please share more detailed information and description to help us clarify your scenario to test.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank">How to Get Your Question Answered Quickly&nbsp;</A></P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Tue, 07 Nov 2023 07:35:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Formula-Help-For-given-columns-and-filter-value-SUM-another/m-p/3519229#M135167 Anonymous 2023-11-07T07:35:16Z