Related Dimension / Measures

Ask the Community
1

Hi,

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.

Thanks
B

2

Hi B,

I think I’m at a lost when you mention this

" 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"

Could you give a real example so I can better imagine?
Best,

3

Hi Tuan

Thanks for your response, please see a real example below, hope this helps.

I have a customer table and a sales table.

The customer_id is the primary key in the customer table, with it being a foreign key in the sales table.

I want to build a measure to sum the cost in the sales table.

I then want to see this measure as a dimension for customers in the customer table, so I can then create measures off this, such as; average_sales_per_customer.

Thanks
Ben