Calculating RTY

[nguyea25]

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

[v-deddai1-msft · Accepted 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

[scisteph]

I have tried creating the measure suggested, but I am getting all 0.00%. I have no idea what I am doing wrong. 

[nguyea25]

Thank you so much! It worked flawlessly.

Regards,

Andrew

[Krd603206]

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?