https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-in-DAX/m-p/2148326#M49461 <P>Hello, I am trying to do calculation below:&nbsp;</P><P>The logic is to count rows that have same color but later date</P><P>&nbsp;</P><P>What would be the dax formula for this?</P><P><img /></P><P>&nbsp;</P> Thu, 21 Oct 2021 13:58:11 GMT kangx322 2021-10-21T13:58:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-in-DAX/m-p/2148326#M49461 <P>Hello, I am trying to do calculation below:&nbsp;</P><P>The logic is to count rows that have same color but later date</P><P>&nbsp;</P><P>What would be the dax formula for this?</P><P><img /></P><P>&nbsp;</P> Thu, 21 Oct 2021 13:58:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-in-DAX/m-p/2148326#M49461 kangx322 2021-10-21T13:58:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-in-DAX/m-p/2148618#M49475 <P>I think this will do it.</P> <P>Please post data (not a picture) next time.</P> <LI-CODE lang="markup">ColumnW = VAR _color = TableL[Color] VAR _rowdate = TableL[Date] RETURN COUNTROWS(FILTER(TableL, TableL[Color] = _color &amp;&amp; TableL[Date] &gt; _rowdate))</LI-CODE> Thu, 21 Oct 2021 15:50:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/COUNTIFS-in-DAX/m-p/2148618#M49475 HotChilli 2021-10-21T15:50:38Z