Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Like this?
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
43 | |
26 | |
21 |