Forum Discussion
Solved
Countrows(Filter) and Calculate(Countrows, Filter) not giving the same results
Hi all, I am trying to add a calculated column to my Table1 to count the number of rows in the Table2 where Table2[vin] = Table1[VIN Num]. At first I wrote this formula: Formula1 = COUNTROWS(F...
OK,
so, it semms that the issue xas that there was a relationship (via a third table) between Table1 and Table2. I deleted the relationship and now have correct results.
If anyone has info on how calculate behaves with relationships in calculated column, I'd live to learn more because for now I don't get it.
