Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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%
Solved! Go to 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 , 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
@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
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |