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.
So I am trying to estimate the time(in hours) of an assembly based on past averages. I am also trying to calculate the estimated division of hours based on past averages for each department of the company, ie each step the assembly went through during production.
I created 4 measures:
1. Total Hours for Assembly. I was trying to calculate the total hours. (Resource is the department during production).
2. Average Assembly in Percent. I was trying to calculate the average times in the past so I can estimate times in the future. I divided the hours per resource by the total hours to get a decimal.
3. Estimated Hours. I was trying to calculate the estimated times for future assemblies, so I multiplied how many units haven't been built(left to ship) by the time per unit.
4. Estimated Division of Hours. I multiplied the past assembly averages by the estimated hours, to get the estimated hours for each resource during production.
But when I make a table, for some assemblies, there are blank spaces in the estimated division of hours (as seen in the pic below). And when I manually calculate the estimated division of hours (past average percents * estimated hours for assembly) I do not get these numbers. I am not sure what is wrong and why some assemblies work, but not all. Any help would be greatly appreciated!!
Solved! Go to Solution.
As I was recreating the problem to post a sample doc, I realized that the original data was messed up. So I restarted and now it works!
Thanks anyways!!
@Anonymous , Ideally Multiplication should be Sum(A*B), But as we can not do that across the table we need to make sure it happens across a common context.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
As I was recreating the problem to post a sample doc, I realized that the original data was messed up. So I restarted and now it works!
Thanks anyways!!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |