Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Community!
I am trying to calculate rolled yield over a time period, but cant get the correct result.
Date | Process | OK+R | Total | Yield |
19/3-2024 | Process A | 2010 | 2016 | 0.99702381 |
18/3-2024 | Process A | 1234 | 1244 | 0.991961415 |
19/3-2024 | Process B | 1161 | 1183 | 0.981403212 |
18/3-2024 | Process B | 1822 | 1865 | 0.9769437 |
And this is the result over the time period. First sum OK+R and Total per process, then dividing them to get yield per process.
Process | OK+R | Total | Yield |
Process A | 3244 | 3260 | 0.995092025 |
Process B | 2983 | 3048 | 0.978674541 |
Rolled yield = 0.995092025*0.978674541 = 0.973871
I need a measure to do this calculation. Tried with variants of ProductX but cant get the correct rolled yield number. Any help appriciated!
Solved! Go to Solution.
Hi @mrhish
please try
Yied =
PRODUCTX (
VALUES ( 'Table'[Process] ),
DIVIDE ( [OK+R Measure], [Total Measure] )
)
Hi @mrhish
please try
Yied =
PRODUCTX (
VALUES ( 'Table'[Process] ),
DIVIDE ( [OK+R Measure], [Total Measure] )
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
30 | |
16 | |
14 | |
14 | |
9 |