topic Re: How to show total of each product and product wise order quantity per customer in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200940#M116361 <P>I used a different configuration in the filter which got me the expected result. thanks</P> Sat, 22 Apr 2023 12:02:07 GMT jj-alex 2023-04-22T12:02:07Z How to show total of each product and product wise order quantity per customer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200556#M116327 <P>Hello,</P><P>I am working with the Northwind database where it has separate tables for Customer, Product and Order Detail. I need to show</P><P>the Total of each product along with Customer name, Product name, Quantity ordered. I created a measure for the Total product quantity and added it to the matrix, but then I see the Quantity ordered with blank. I dont want to see any customer in the visual where they have not ordered a particular product. For eg: in the table below, I dont want to see the 2nd and the 5th row as those customers have not ordered any of those products. Please advise how to establish using DAX.</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><P>Customer</P><P>Name</P></TD><TD><P>Product</P><P>Name</P></TD><TD>Quantity Ordered</TD><TD>Total Product Quantity</TD></TR><TR><TD>A</TD><TD>Apple</TD><TD>2</TD><TD>12</TD></TR><TR><TD>B</TD><TD>Apple</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>C</TD><TD>Apple</TD><TD>10</TD><TD>12</TD></TR><TR><TD>B</TD><TD>Orange</TD><TD>7</TD><TD>15</TD></TR><TR><TD>C</TD><TD>Apple</TD><TD>&nbsp;</TD><TD>12</TD></TR><TR><TD>C</TD><TD>Orange</TD><TD>8</TD><TD>15</TD></TR></TBODY></TABLE> Fri, 21 Apr 2023 17:44:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200556#M116327 jj-alex 2023-04-21T17:44:40Z Re: How to show total of each product and product wise order quantity per customer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200768#M116347 <P>&nbsp;</P><P>You need to add a judgment, roughly as follows. Please modify it according to your model information.</P><P>&nbsp;</P><LI-CODE lang="markup">Total Product Quantity = VAR qo = Quantity Ordered VAR result = IF(qo = Blank(),Blank(),SUM(Quantity Ordered)) RETURN result</LI-CODE><P>&nbsp;</P> Sat, 22 Apr 2023 01:46:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200768#M116347 jiaopengzi 2023-04-22T01:46:06Z Re: How to show total of each product and product wise order quantity per customer https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200940#M116361 <P>I used a different configuration in the filter which got me the expected result. thanks</P> Sat, 22 Apr 2023 12:02:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-total-of-each-product-and-product-wise-order/m-p/3200940#M116361 jj-alex 2023-04-22T12:02:07Z