cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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

Announcements

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.