Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue with measures

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!!

  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak 

     

    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!!

2 Replies

  • 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      amitchandak 

       

      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!!