Forum Discussion

iToune's avatar
iToune
Frequent Visitor
4 years ago
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...
Need Help
  • iToune's avatar
    iToune
    4 years ago

    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.

iToune's avatar
iToune
Frequent Visitor
4 years ago

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.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi iToune 

    You can try this calculated column,

     

    count = CALCULATE(COUNTROWS(Table2),FILTER(ALL(Table2),Table2[vin]=Table1[VIN Num]))

     

     

     

     

    Best Regards,

    Community Support Team _Tang

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