Forum Discussion
Count in two related tables
If you drag a Matrix visual to your canvas, with ID in Rows, and the measure totalTAreas in Values, I think it will give you the result you need.
Or you can add a column as described by Baskar, though I can't see from your requirements why it must be a column.
Note that columns can't be used is some situations (e.g. axis on a scatter plot), measures are generally more efficient, but measures can't be used as slicers.
No, i explained myself in a bad way i need to print table 1 and i want the count of all the tasks each id has. Not a global count, that is why i need that column i cheked the links and are nice but in this case i need the calculated colum.
Thanks for the information about measures and columns i found it interesting :)
Resident Rockstar1. create relationship between these two table.
2. Create calculated column on Table 1
Column =Calculate( COUNTROWS(RELATEDTABLE('Table 2')))
am sure it will help u, if not let me know i will help u my friend .
The second solution doesn't work. I go to investigate that CALCULATE. i think that is the solution to my problem