https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-the-total-of-locations-with-the-same-product-as-the/m-p/1849860#M39518 <P>This is a bit urgent. I wish I could get help soon.</P><P>Thanks!</P> Wed, 19 May 2021 01:34:17 GMT Anonymous 2021-05-19T01:34:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-the-total-of-locations-with-the-same-product-as-the/m-p/1849846#M39517 <P>I am trying to&nbsp;count the total of locations with the same product as the best seller?</P><P><img /></P><P>Here is the table, SKU:77Lam05110 is the top sellers for 6 venues. At the bottom of right hand side, I want to get a Sum of the count(6 here).</P><P>Below is my code, but it does not work.</P><P><img /></P><P>Can any one help me, I will really appreciate!</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 19 May 2021 01:42:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-the-total-of-locations-with-the-same-product-as-the/m-p/1849846#M39517 Anonymous 2021-05-19T01:42:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-the-total-of-locations-with-the-same-product-as-the/m-p/1849860#M39518 <P>This is a bit urgent. I wish I could get help soon.</P><P>Thanks!</P> Wed, 19 May 2021 01:34:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-the-total-of-locations-with-the-same-product-as-the/m-p/1849860#M39518 Anonymous 2021-05-19T01:34:17Z