Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Measure for data from 2 different tables

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?

2 REPLIES 2
amitchandak
Super User
Super User

@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])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Ludia
Helper I
Helper I

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.