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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
kasife
Helper V
Helper V

Total sales and target per product for each salesperson

Hi Guys,

I have two fact tables that are related by product. I need to fetch the total goal per product that is in the Goals table and relate it to the salesperson that is in the Productivity Table. How could I do?
In the image below, seller x made sales of the product arapongas and cianorte.

kasife_1-1687389733461.png

This is the result I would like to get without having to use any tracking. I would like to make it to measure

Seller x sold 64 units of arapondas and cyanorte products last month (goal 80), so the percentage sold is 80%

kasife_3-1687390092330.png

 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@kasife , I think you need common date and product table in this case

 

example new table

Product= distinct(UNION(distinct(Sales[Product]), distinct(Productivity[Product])))

 

and then these type of measures can help

Total Sales = CALCULATE(SUM(Productivity[Sales]))

Total Target = SUM(Goals[Target])

Percentage Sold = DIVIDE([Total Sales], [Total Target])

 

 

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

 

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@kasife , I think you need common date and product table in this case

 

example new table

Product= distinct(UNION(distinct(Sales[Product]), distinct(Productivity[Product])))

 

and then these type of measures can help

Total Sales = CALCULATE(SUM(Productivity[Sales]))

Total Target = SUM(Goals[Target])

Percentage Sold = DIVIDE([Total Sales], [Total Target])

 

 

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

 

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak  I already have both tables, but it is bringing me the percentage of total sales and what I would like is to get the percentage only of the products that are related to each seller

kasife_0-1687437733642.png

When I select the products I can get the results

kasife_1-1687437900594.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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