Counter Issue

[aminsaleh]

Hi everybody

Kindly have a look the below image. The item shows a number 1, which represents how many rows in the child table. 

Can I the know the expression used to evaluate that number. 

I am trying to move data from this table to a new table and for the item column I want to but as number value so for example the item number is 1 it will show 1 and if 2 it shows 2. ets.

>> Can I have the same row counter in parent table after I apply some filters. For example I filter all row of customers who want to buy chairs for example.

Thanks 

[TeeSee1 · Accepted solution]

COUNT(FILTER("CHILD TABLE", [ref to PARENT]=[_THISROW]))

this assumes that the expression is placed in the PARENT table as one of its Columns

[aminsaleh]

@TeeSee1 

Thank you very much

on the same table for example I want to count how many rows after certain filters are done.

I wrote this

COUNT(FILTER("Orders", [Order ID]=[_THISROW]))

where order ID is unique but it only shows 1 , it does not calculate rows number. 

in my case it should see how many IDs and out the number.