topic Re: DAX: ADDCOLUMNS &amp; SUMMARIZE with Filter - Need Help in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1713426#M35355 <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="285661" data-lia-user-login="jameszhang0805" class="lia-mention lia-mention-user">jameszhang0805</a> That works! Thank you very much! Wed, 10 Mar 2021 10:29:19 GMT Power_MN 2021-03-10T10:29:19Z DAX: ADDCOLUMNS & SUMMARIZE with Filter - Need Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1712078#M35323 Hello everybody, Unfortunately, I can't get any further with one issue. I would like to add a filter to the following DAX command that filters for a specific country. ADDCOLUMNS( SUMMARIZE(Table1, Table1[supplier], Table1[product]), "Average Price", [Average Price] ) --&gt; Here I would like to filter for the country "America" Does anyone know a solution for my issue? Thank you so much! Michael Tue, 09 Mar 2021 17:01:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1712078#M35323 Power_MN 2021-03-09T17:01:48Z Re: DAX: ADDCOLUMNS & SUMMARIZE with Filter - Need Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1712685#M35340 <P>Please try :</P><LI-CODE lang="markup">AMAveragePrice = ADDCOLUMNS ( CALCULATETABLE ( SUMMARIZE ( Table1, Table1[supplier], Table1[product] ), Table1[supplier] = "America" ), "Average Price", [Average Price] )</LI-CODE> Wed, 10 Mar 2021 04:01:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1712685#M35340 jameszhang0805 2021-03-10T04:01:16Z Re: DAX: ADDCOLUMNS & SUMMARIZE with Filter - Need Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1713426#M35355 <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="285661" data-lia-user-login="jameszhang0805" class="lia-mention lia-mention-user">jameszhang0805</a> That works! Thank you very much! Wed, 10 Mar 2021 10:29:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1713426#M35355 Power_MN 2021-03-10T10:29:19Z Re: DAX: ADDCOLUMNS & SUMMARIZE with Filter - Need Help https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1713453#M35357 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="289608" data-lia-user-login="Power_MN" class="lia-mention lia-mention-user">Power_MN</a>&nbsp;YOU are welcome. please click accept solution. thanks.&nbsp;</P> Wed, 10 Mar 2021 10:43:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-ADDCOLUMNS-amp-SUMMARIZE-with-Filter-Need-Help/m-p/1713453#M35357 jameszhang0805 2021-03-10T10:43:22Z