https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/FILTER-NOT-CONTAINS/m-p/2851983#M91462 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;</P> <P>please try</P> <LI-CODE lang="markup">Sales := CALCULATE ( [Sales Amount], NOT ( 'Sales'[Article] IN { "Article1", "Article2", "Article3", "Article4", "Article5" } ) )</LI-CODE> Wed, 19 Oct 2022 18:55:30 GMT tamerj1 2022-10-19T18:55:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/FILTER-NOT-CONTAINS/m-p/2851881#M91456 <P>Hi all!</P> <P>Let's say I have a table with values and string.</P> <P>In the column Article I have different strings.</P> <P>Now I would like to calculate the SUM of the column Quantity but I would like to exclude 5 different articles here.</P> <P>How would you do that in such a measure?</P> <LI-CODE lang="markup">Sales := CALCULATE ( [Sales Amount], 'Sales'[Article] = "Table", 'Sales'[Article] = "Desk" )</LI-CODE> Wed, 19 Oct 2022 17:29:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/FILTER-NOT-CONTAINS/m-p/2851881#M91456 joshua1990 2022-10-19T17:29:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/FILTER-NOT-CONTAINS/m-p/2851983#M91462 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;</P> <P>please try</P> <LI-CODE lang="markup">Sales := CALCULATE ( [Sales Amount], NOT ( 'Sales'[Article] IN { "Article1", "Article2", "Article3", "Article4", "Article5" } ) )</LI-CODE> Wed, 19 Oct 2022 18:55:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/FILTER-NOT-CONTAINS/m-p/2851983#M91462 tamerj1 2022-10-19T18:55:30Z