topic Sum by Category/Type without ignoring other filters in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-by-Category-Type-without-ignoring-other-filters/m-p/1875106#M40231 <P>Hi All,&nbsp;</P><P>&nbsp;</P><P>I would like to sum up the amount by Type. I know that ALLEXCEPT work in Scenario 1.&nbsp;</P><P>&nbsp;</P><P>Is there anyone can help to create a measure that could work for all scenario?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Scenario 1</TD><TD>Scenario 2</TD><TD>Scenario 3</TD><TD>Scenario 4</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Filter 1 (Category):</TD><TD>All Selected</TD><TD>m</TD><TD>All Selected</TD><TD>m</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Filter 2 (Year):</TD><TD>All Selected</TD><TD>All Selected</TD><TD>2020</TD><TD>2021</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Claim No</TD><TD>Type</TD><TD>Category</TD><TD>Year</TD><TD>Amount</TD><TD>Sum by Type</TD><TD>Sum by Type</TD><TD>Sum by Type</TD><TD>Sum by Type</TD></TR><TR><TD>a</TD><TD>x</TD><TD>l</TD><TD>2019</TD><TD>100</TD><TD>600</TD><TD>NA</TD><TD>NA</TD><TD>NA</TD></TR><TR><TD>d</TD><TD>x</TD><TD>m</TD><TD>2020</TD><TD>300</TD><TD>600</TD><TD>500</TD><TD>300</TD><TD>NA</TD></TR><TR><TD>e</TD><TD>x</TD><TD>m</TD><TD>2019</TD><TD>200</TD><TD>600</TD><TD>500</TD><TD>NA</TD><TD>NA</TD></TR><TR><TD>b</TD><TD>y</TD><TD>m</TD><TD>2021</TD><TD>100</TD><TD>200</TD><TD>100</TD><TD>NA</TD><TD>100</TD></TR><TR><TD>f</TD><TD>y</TD><TD>n</TD><TD>2021</TD><TD>100</TD><TD>200</TD><TD>NA</TD><TD>NA</TD><TD>NA</TD></TR><TR><TD>c</TD><TD>z</TD><TD>n</TD><TD>2020</TD><TD>100</TD><TD>100</TD><TD>NA</TD><TD>100</TD><TD><P>NA</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks!</P> Tue, 01 Jun 2021 12:46:16 GMT PowerBIOrg 2021-06-01T12:46:16Z Sum by Category/Type without ignoring other filters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-by-Category-Type-without-ignoring-other-filters/m-p/1875106#M40231 <P>Hi All,&nbsp;</P><P>&nbsp;</P><P>I would like to sum up the amount by Type. I know that ALLEXCEPT work in Scenario 1.&nbsp;</P><P>&nbsp;</P><P>Is there anyone can help to create a measure that could work for all scenario?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Scenario 1</TD><TD>Scenario 2</TD><TD>Scenario 3</TD><TD>Scenario 4</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Filter 1 (Category):</TD><TD>All Selected</TD><TD>m</TD><TD>All Selected</TD><TD>m</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Filter 2 (Year):</TD><TD>All Selected</TD><TD>All Selected</TD><TD>2020</TD><TD>2021</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Claim No</TD><TD>Type</TD><TD>Category</TD><TD>Year</TD><TD>Amount</TD><TD>Sum by Type</TD><TD>Sum by Type</TD><TD>Sum by Type</TD><TD>Sum by Type</TD></TR><TR><TD>a</TD><TD>x</TD><TD>l</TD><TD>2019</TD><TD>100</TD><TD>600</TD><TD>NA</TD><TD>NA</TD><TD>NA</TD></TR><TR><TD>d</TD><TD>x</TD><TD>m</TD><TD>2020</TD><TD>300</TD><TD>600</TD><TD>500</TD><TD>300</TD><TD>NA</TD></TR><TR><TD>e</TD><TD>x</TD><TD>m</TD><TD>2019</TD><TD>200</TD><TD>600</TD><TD>500</TD><TD>NA</TD><TD>NA</TD></TR><TR><TD>b</TD><TD>y</TD><TD>m</TD><TD>2021</TD><TD>100</TD><TD>200</TD><TD>100</TD><TD>NA</TD><TD>100</TD></TR><TR><TD>f</TD><TD>y</TD><TD>n</TD><TD>2021</TD><TD>100</TD><TD>200</TD><TD>NA</TD><TD>NA</TD><TD>NA</TD></TR><TR><TD>c</TD><TD>z</TD><TD>n</TD><TD>2020</TD><TD>100</TD><TD>100</TD><TD>NA</TD><TD>100</TD><TD><P>NA</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks!</P> Tue, 01 Jun 2021 12:46:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-by-Category-Type-without-ignoring-other-filters/m-p/1875106#M40231 PowerBIOrg 2021-06-01T12:46:16Z Re: Sum by Category/Type without ignoring other filters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-by-Category-Type-without-ignoring-other-filters/m-p/1875147#M40235 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="284483" data-lia-user-login="PowerBIOrg" class="lia-mention lia-mention-user">PowerBIOrg</a>&nbsp;</P><P>Please check the below.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P><STRONG><EM>Sum by Type Measure =</EM></STRONG><BR /><EM>CALCULATE (</EM><BR /><EM>SUM ( 'Table'[Amount] ),</EM><BR /><EM>ALLSELECTED ( 'Table' ),</EM><BR /><EM>VALUES ( 'Table'[Type] )</EM><BR /><EM>)</EM></P><P>&nbsp;</P><P>&nbsp;</P><P><A href="https://www.dropbox.com/s/sgydb85cmf1uuum/powerbiorg.pbix?dl=0" target="_self">https://www.dropbox.com/s/sgydb85cmf1uuum/powerbiorg.pbix?dl=0</A>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><FONT face="”calibri" color="”#0000FF”"><STRONG>Hi, My name is Jihwan Kim. </STRONG></FONT></P><P>&nbsp;</P><P><FONT face="”calibri" color="”#0000FF”"><STRONG>If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up. </STRONG></FONT></P><P>&nbsp;</P><P><FONT face="”calibri" color="”#0000FF”">Linkedin: linkedin.com/in/jihwankim1975/</FONT></P><P><FONT face="”calibri" color="”#0000FF”">Twitter: twitter.com/Jihwan_JHKIM</FONT></P> Tue, 01 Jun 2021 13:06:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-by-Category-Type-without-ignoring-other-filters/m-p/1875147#M40235 Jihwan_Kim 2021-06-01T13:06:48Z