Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
66 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |