Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I'm new to the community and new to PowerBI. I'm trying to calculate a rolled throughput yield column but I'm struggling to find the best way to do it. Hopefully I'm providing enough information to solve the problem.
The Accept and Reject Qty columns are measures where I use COUNT() to count the number of Accepts or Rejects in a large table then filtered by Process. The Yield column is then just Accept Qty / Total Qty. I'd like to get the RTY column which is the Product of all of the prior Yields. For example Process 3 RTY is 99% x 98% x 95%.
Process No | Process Desc | Accept Qty | Reject Qty | Yield | RTY |
1 | Process 1 | 99 | 1 | 99% | 99% |
2 | Process 2 | 98 | 2 | 98% | 97.02% |
3 | Process 3 | 95 | 5 | 95% | 92.14% |
Thanks!
Andrew
Solved! Go to Solution.
Hi @nguyea25 ,
Would you please try to use the following measure:
RTY =
PRODUCTX (
FILTER ( ALL ( 'Table' ), 'Table'[Process No] <= MAX ( 'Table'[Process No] ) ),
[Yield]
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @nguyea25 ,
Would you please try to use the following measure:
RTY =
PRODUCTX (
FILTER ( ALL ( 'Table' ), 'Table'[Process No] <= MAX ( 'Table'[Process No] ) ),
[Yield]
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I have tried creating the measure suggested, but I am getting all 0.00%. I have no idea what I am doing wrong.
Thank you so much! It worked flawlessly.
Regards,
Andrew
Hi nguyea25
I've tried to replicate this in my own data but cannot get the qty accept and reject to accumulate as they progress through the process steps, would you mind sharing your count() with filter dax?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |