countrows matching date

Hi 1984 ,

Based on the information you provided, I created an example. You can follow the steps below:

1.Add a column to count the number of rows in Table2.

Number of Rows = CALCULATE(COUNTROWS(Table2), FILTER(Table2, Table2[Column1] = 'Table'[Date]))

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}