Total sales and target per product for each salesperson

[kasife]

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.

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%

[amitchandak · Accepted solution]

@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

[kasife]

@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

When I select the products I can get the results