https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Count-product-filter/m-p/1677314#M34354 <P>Perhaps something along the lines of countrows(values(productdim[product]))</P> <P>&nbsp;</P> <P>Kind regards, Steve.&nbsp;</P> Fri, 19 Feb 2021 12:01:32 GMT stevedep 2021-02-19T12:01:32Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Count-product-filter/m-p/1676792#M34342 <P>Hello, I have a report matrix of product and category, my problem is apply a DAX measure that count row for every catgory with numb of product. I need a DAX cause the report should work with different filter applied&nbsp;</P><P>&nbsp;</P><P>Here a pic of what I get, and in orange how should be do it (maybe with just the count in the global rows)</P><P><img /></P><P>thanks to everyone try to answer!</P> Fri, 19 Feb 2021 09:37:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Count-product-filter/m-p/1676792#M34342 Anonymous 2021-02-19T09:37:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Count-product-filter/m-p/1677314#M34354 <P>Perhaps something along the lines of countrows(values(productdim[product]))</P> <P>&nbsp;</P> <P>Kind regards, Steve.&nbsp;</P> Fri, 19 Feb 2021 12:01:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Count-product-filter/m-p/1677314#M34354 stevedep 2021-02-19T12:01:32Z