Measure for data from 2 different tables

[Anonymous]

I have a table containing forecasts per month, per customer per product and a table containing actual sales per day, per customer, per product. My goal is to create summarized bar charts that show which 5 customers for example have more sales than forecasted, or which products where bought more than forecasted. I assumed that I would need a measure for this, however since this is between 2 different tables I don't know where to start and where to put the measure?

[amitchandak]

@Anonymous,

You need to have a common customer. If you do not have one create like

Customer = distinct(union(all(sales[customer]),all(forecast[customer])))

[Ludia]

Hi, first of first, the measure doesn't need to be in any table, but based on your description, I think you need to create the relationship for these 2 tables (by customer, or by product, please verify it based on your data granularity

After that, you can create a measure or 2 measure to achieve it easily, if you need, I can help more on it

Cheers