cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

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%

1 ACCEPTED SOLUTION
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

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

2 REPLIES 2
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

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

Helper V

@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