topic Dax Measure, Total not showing the sum of the calculation in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Measure-Total-not-showing-the-sum-of-the-calculation/m-p/862705#M6995 <P>Hi, guys, Im having a hard time here, trying to get a with the proper DAX formula, I have a measure = (a/b)&nbsp;</P><P>But for the total I want the sum of the values for that column, instead the total A / Total B.</P><P>Im going to attach an image of an example model to better explain my problem.</P><P>&nbsp;</P><P><img /></P><P>I tried to use a combination of sumx with values (country for example), but it works only for that attribute, If I remove for example country, and add brand to the pivot the measure shows the wrong total.</P><P>Thanks a lot for your help</P> Mon, 02 Dec 2019 21:09:40 GMT ctrip77 2019-12-02T21:09:40Z Dax Measure, Total not showing the sum of the calculation https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Measure-Total-not-showing-the-sum-of-the-calculation/m-p/862705#M6995 <P>Hi, guys, Im having a hard time here, trying to get a with the proper DAX formula, I have a measure = (a/b)&nbsp;</P><P>But for the total I want the sum of the values for that column, instead the total A / Total B.</P><P>Im going to attach an image of an example model to better explain my problem.</P><P>&nbsp;</P><P><img /></P><P>I tried to use a combination of sumx with values (country for example), but it works only for that attribute, If I remove for example country, and add brand to the pivot the measure shows the wrong total.</P><P>Thanks a lot for your help</P> Mon, 02 Dec 2019 21:09:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Measure-Total-not-showing-the-sum-of-the-calculation/m-p/862705#M6995 ctrip77 2019-12-02T21:09:40Z Re: Dax Measure, Total not showing the sum of the calculation https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Measure-Total-not-showing-the-sum-of-the-calculation/m-p/862993#M6999 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="87983" data-lia-user-login="ctrip77" class="lia-mention lia-mention-user">ctrip77</a>&nbsp;Please use following measure to get the correct totals.</P><LI-CODE lang="markup">Measure = SUMX('Table',DIVIDE('Table'[Cost],'Table'[area Ft2],0))</LI-CODE> Tue, 03 Dec 2019 04:13:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-Measure-Total-not-showing-the-sum-of-the-calculation/m-p/862993#M6999 Anonymous 2019-12-03T04:13:11Z