Related Function and relationships


#1

Hey,

How does a related function calculate in the below scenario when the cross filter is set to single direction.

The function is placed in the fact table and referencing the dimension table. The filter direction is from the dimension to the fact table. The rules state, a relationship must exist. The filter direction of the relationship is from the top going down yet the function is from the bottom of the stream going up.

Does it not matter which direction the filter is going. Also where video goes through related function in a measure.

For example in the sales table I place
Total Sales =
SUMX (
‘Sales’,
‘Sales’[Quantity] * RELATED (‘Product’[Unit Price] )
)

Thanks in Advance.
Elizabeth Tachjian


#2

Can you show the relationships window. The formula looks fine to me, is it not working? The dimension table Product holds unique records?