I am trying to work out whether it is possible to return a measure as field within a related table? Please see example below:
I have two tables A & B. A has a 1:n relationship to B. B has a measure within it called
total, which is a count of the rows in B.
I want to return
total for each row within A. Alternatively, I want to calculate in A, the number of rows in B, without having a measure in B
Any help on this would be much appreciated.