Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have the below summarised data in a graoh:
The graph shows how many parts were produced on each machine.
For the parts that are produced, they are packed in to stillages. Different machines have amounts of parts that can be packed in to a stillage.
For examples, machine 0, 1, 3 and 4 have 24 parts packed in to one stillage. Machine 3 has 12 parts packed in to 1 stillage. MAchine 2 has 15 parts packed in to one stillage. MAchine 9 has 32 parts packed in to one stillage.
I need to see this graph how it is, by machine, but by the number of stillages packed, nt parts produced. Obviously, if they all had 24 parts per machine I could do a simple division. But, how do I do this division when different machines have a different division number?
Solved! Go to Solution.
Hi @rebrow31 ,
You may refer to my sample to learn more details. I hope it could help you solve your problem.
Parts:
Stillages:
Create an relationshio by Machine columns.
Measure:
Stillage can be created by each machine =
QUOTIENT(SUM(Parts[Parts]),SUM(Stillages[Amount]))
Remaining parts = SUM(Parts[Parts]) - SUM(Stillages[Amount])*[Stillage can be created by each machine]
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have made a table with all of the machines numbers and the numbers I want it divided by. How would I go about joining them to the production table?
Hi @rebrow31 ,
You may refer to my sample to learn more details. I hope it could help you solve your problem.
Parts:
Stillages:
Create an relationshio by Machine columns.
Measure:
Stillage can be created by each machine =
QUOTIENT(SUM(Parts[Parts]),SUM(Stillages[Amount]))
Remaining parts = SUM(Parts[Parts]) - SUM(Stillages[Amount])*[Stillage can be created by each machine]
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked perfectly, thank you so much for your help!
Hi @rebrow31 , Can you create a table with the target values and join them into the table and work your calculation from there?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |