https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-two-joined-table/m-p/3357391#M157525 <P>Hi. I have two tables Stores and Products. And i want to countrows using crossfilter for join tables, also i have some conditions in countingrows. How can i fix it? Here is my DAX:</P><DIV><DIV><SPAN>COUNTROWS 90 DAY = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>( </SPAN><SPAN>DISTINCT</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>CROSSJOIN</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Store</SPAN><SPAN>[Store Code]</SPAN><SPAN>),</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Product'</SPAN><SPAN>[Product Code]</SPAN><SPAN>)),</SPAN><SPAN>Store</SPAN><SPAN>[Store Code]</SPAN><SPAN>,</SPAN><SPAN>'Product'</SPAN><SPAN>[Product Code]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"C1"</SPAN><SPAN>,</SPAN><SPAN>[Stock qty (before 90 days)]</SPAN><SPAN>,</SPAN><SPAN>"C2"</SPAN><SPAN>,</SPAN><SPAN>[Stock difference 90 days]</SPAN><SPAN>,</SPAN><SPAN>"C3"</SPAN><SPAN>,</SPAN><SPAN>[Sales between today and 90 days before]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>[C1]</SPAN><SPAN>&gt;</SPAN><SPAN>0</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>[C2]</SPAN><SPAN>&gt;=</SPAN><SPAN>0</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>[C3]</SPAN><SPAN>=</SPAN><SPAN>0</SPAN><SPAN>))))</SPAN></DIV></DIV> Mon, 31 Jul 2023 07:24:16 GMT aqil311 2023-07-31T07:24:16Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-two-joined-table/m-p/3357391#M157525 <P>Hi. I have two tables Stores and Products. And i want to countrows using crossfilter for join tables, also i have some conditions in countingrows. How can i fix it? Here is my DAX:</P><DIV><DIV><SPAN>COUNTROWS 90 DAY = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>COUNTROWS</SPAN><SPAN>( </SPAN><SPAN>DISTINCT</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>SUMMARIZE</SPAN><SPAN>(</SPAN><SPAN>CROSSJOIN</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>Store</SPAN><SPAN>[Store Code]</SPAN><SPAN>),</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Product'</SPAN><SPAN>[Product Code]</SPAN><SPAN>)),</SPAN><SPAN>Store</SPAN><SPAN>[Store Code]</SPAN><SPAN>,</SPAN><SPAN>'Product'</SPAN><SPAN>[Product Code]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"C1"</SPAN><SPAN>,</SPAN><SPAN>[Stock qty (before 90 days)]</SPAN><SPAN>,</SPAN><SPAN>"C2"</SPAN><SPAN>,</SPAN><SPAN>[Stock difference 90 days]</SPAN><SPAN>,</SPAN><SPAN>"C3"</SPAN><SPAN>,</SPAN><SPAN>[Sales between today and 90 days before]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>[C1]</SPAN><SPAN>&gt;</SPAN><SPAN>0</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>[C2]</SPAN><SPAN>&gt;=</SPAN><SPAN>0</SPAN><SPAN> &amp;&amp; </SPAN><SPAN>[C3]</SPAN><SPAN>=</SPAN><SPAN>0</SPAN><SPAN>))))</SPAN></DIV></DIV> Mon, 31 Jul 2023 07:24:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-two-joined-table/m-p/3357391#M157525 aqil311 2023-07-31T07:24:16Z