https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-up-on-row-level-for-Total-Number/m-p/2209688#M52104 <P>I have a sales table and a budget table.</P><P>The sales table shows me the sales for each article and the budget table shows me the budget for each article, if available. There is no budget for every article. Both tables are linked to an attribute list that contains all articles.</P><P>Sales</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Article</TD><TD>Sales</TD></TR><TR><TD>01.01.2021</TD><TD>A</TD><TD>500</TD></TR><TR><TD>01.01.2021</TD><TD>B</TD><TD>550</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Budget</P><TABLE border="1"><TBODY><TR><TD>Article</TD><TD>Budget</TD></TR><TR><TD>A</TD><TD>500</TD></TR><TR><TD>C</TD><TD>600</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now, I would like to SUM the minimum Budget and Sum for each article.</P><P>For that, I use a simple MIN ([Sales], [Budget]).</P><P>Now, if I use a matrix to show the result for each article, then it works.</P><P>But if a drill the data up to department or country level, then I get a false result.</P><P>Do I need an iterative function?</P><P>This is not working: SUMX (Attribute List, MIN ([Sales], [Budget])</P> Fri, 26 Nov 2021 15:12:00 GMT joshua1990 2021-11-26T15:12:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-up-on-row-level-for-Total-Number/m-p/2209688#M52104 <P>I have a sales table and a budget table.</P><P>The sales table shows me the sales for each article and the budget table shows me the budget for each article, if available. There is no budget for every article. Both tables are linked to an attribute list that contains all articles.</P><P>Sales</P><TABLE border="1"><TBODY><TR><TD>Date</TD><TD>Article</TD><TD>Sales</TD></TR><TR><TD>01.01.2021</TD><TD>A</TD><TD>500</TD></TR><TR><TD>01.01.2021</TD><TD>B</TD><TD>550</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Budget</P><TABLE border="1"><TBODY><TR><TD>Article</TD><TD>Budget</TD></TR><TR><TD>A</TD><TD>500</TD></TR><TR><TD>C</TD><TD>600</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Now, I would like to SUM the minimum Budget and Sum for each article.</P><P>For that, I use a simple MIN ([Sales], [Budget]).</P><P>Now, if I use a matrix to show the result for each article, then it works.</P><P>But if a drill the data up to department or country level, then I get a false result.</P><P>Do I need an iterative function?</P><P>This is not working: SUMX (Attribute List, MIN ([Sales], [Budget])</P> Fri, 26 Nov 2021 15:12:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-up-on-row-level-for-Total-Number/m-p/2209688#M52104 joshua1990 2021-11-26T15:12:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-up-on-row-level-for-Total-Number/m-p/2209821#M52115 <P><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> , Try like</P> <P>SUMX (values(Attribute List[Article]), MIN ([Sales], [Budget])</P> Fri, 26 Nov 2021 17:11:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-up-on-row-level-for-Total-Number/m-p/2209821#M52115 amitchandak 2021-11-26T17:11:59Z