I am very new to Power BI and the DAX language and I could use the community's help figuring out this problem. My data set is a table of starts and scraps by task and week. I would like to be able to calculate and display the yield of individual tasks over the time frame and the yield over all tasks by week.
| Process step | Starts | Scrap | Week |
| A | 100 | 13 | 12 |
| B | 87 | 6 | 12 |
| C | 95 | 5 | 12 |
| D | 90 | 2 | 12 |
| E | 88 | 5 | 12 |
| A | 118 | 14 | 13 |
| B | 104 | 4 | 13 |
| C | 100 | 6 | 13 |
| D | 96 | 6 | 13 |
| E | 90 | 8 | 13 |
| A | 102 | 13 | 14 |
| B | 89 | 6 | 14 |
| C | 97 | 5 | 14 |
| D | 92 | 2 | 14 |
| E | 90 | 5 | 14 |
I've been able to calculate yield by task by creating a measure: Task Yield = 1-sum(Table[starts])/(sum Table[scraps]). However, it does not respond when I slice the visual by week.
I have not been able to figure out yield how to calculate yield by week. I'd like to calculate it as Week Yield = Task A Yield * Task B Yield * Task C Yield * Task D Yield * Task E Yield , but I don't know how to go about doing that in DAX.
