DAX measure across multiple tables

[jayjay0306]

Hi experts,

I hope you can help me with a challenge:

I have the following datamodel (simplified): 

In a report I can make a visualization which shows the following:

But I need to make a DAX measure, which shows the following:

Without adding the customer from the "customer dimension".

I have tried the following:

Sale by Brand = SUMX(SUMMARIZE(Customer,Customer[Customer Name],"Sale_",CALCULATE(SUM[Sale],CROSSFILTER('Product'[PRODUCT_KEY],'Sales North'[PRODUCT_KEY],Both)), CROSSFILTER('Product'[PRODUCT_KEY],'Sales South'[PRODUCT_KEY],Both))),[Sale_])

But the outcome is "100%" on all brands?

Can you crack the problem?

It will be much appreciated.

Br,

Jayjay0306

[Anonymous]

Just create 2 Measures and add together in 3rd measure, then slice by Brand:
SalesNorth = SUM(F_Sale_North[Sales])
SalesSouth = SUM(F_Sale_South[Sales])
TotalSales = [SalesNorth] + [SalesSouth]

The Product dimension is a Conformed dimension, so it has a relationship to the facts. This is why dimensional modeling works so well.