calculated measure between to fact tables related with a dimension table

[Gilad]

Hello  ,

I am having issue creating a calculated measure between to fact tables related with a dimension table .

relationship 1: dim company key + item key = fact sales item key+fact sales company key

relationship 2: dim item key = fact cost item key

Items can be sold in each company but the cost is unique for each item cross companies.

I need to calculate unit cost * quantity

sum(unit cost) * sum(quantity) result to be correct at item key level but the total is wrong , 

please advice

[v-zhangti]

Hi, @Gilad 

Has your problem been solved yet? If not, can you tell what kind of output you expect based on the data you provided?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ · Accepted solution]

hi @Gilad ,

try write your measure like:

Cost Measure = 

SUMX(

    sales,

    sales[quantity]*RELATED(cost[Unit Cost])

)