I have 2 tables/views with the following fields:

Table/View 1
ID
FromDomain
FromUser
SessionID
ToDomain
Size

Table/View 2
SessionID
ToUser

NOTE: The ToDomain field could easily be in Table/View 2

There is a 1 to many relationship between the tables on SessionID

I want to design a dimension with levels ToDomain and ToUser
and then create a Measure on Size

The size for each Session/ToUser is fine, but the ToDomain value becomes
equivalent to Size * number of ToUsers for the related Session

How can I get the ToDomain value to be the normalised value?

Eg.
if I have Session 1 with a Size of 246 and Session 1 has a relationship
with user1, user2, and user3
I want domain1 (or session1) to have a Size value of 246 as well as user1,
user2, and user3 to have the same size (246)


Regards
Aaron