topic Need DAX to sum sales which is not filtered by the Market in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-DAX-to-sum-sales-which-is-not-filtered-by-the-Market/m-p/3158965#M113385 <P>I need to display a column SalesAll which should display number for all markets combined. For Example, SalesAll should display 381 for all the markets. How to achieve that?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 28 Mar 2023 16:25:42 GMT m__m 2023-03-28T16:25:42Z Need DAX to sum sales which is not filtered by the Market https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-DAX-to-sum-sales-which-is-not-filtered-by-the-Market/m-p/3158965#M113385 <P>I need to display a column SalesAll which should display number for all markets combined. For Example, SalesAll should display 381 for all the markets. How to achieve that?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 28 Mar 2023 16:25:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-DAX-to-sum-sales-which-is-not-filtered-by-the-Market/m-p/3158965#M113385 m__m 2023-03-28T16:25:42Z Re: Need DAX to sum sales which is not filtered by the Market https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-DAX-to-sum-sales-which-is-not-filtered-by-the-Market/m-p/3159050#M113388 <P>Hi,</P> <P>I am not sure how your datamodel looks like, but please try something like below.</P> <P>&nbsp;</P> <LI-CODE lang="markup">SalesAll measure: = CALCULATE ( SUM ( tablename[sales] ), ALL ( tablename[market] ) ) </LI-CODE> Tue, 28 Mar 2023 17:10:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-DAX-to-sum-sales-which-is-not-filtered-by-the-Market/m-p/3159050#M113388 Jihwan_Kim 2023-03-28T17:10:38Z