Dynamic Rolled First Pass Yield (RFPY) graph

[ZebraMK]

Hi all,

I am trying to add a graph to my report where I can display RFPY in a dynamic way.

I only have 1 table with all details, I have a column for Prime_total, Prime_Pass and the Prime_fail. (how many units we tested in total and how many passed or failed)

We also have a column called "dashboard" and a column for "Process".

Processes are subsets of the dashboard.

Example:

Dashboard A contains

Process ABC

Dashboard B contains

Process DEF

Dashboard C contains

Process AEC 

Using these fields I have created a measure that calculates the first pass yield; 

FPY = DIVIDE(SUM('mqsprod global_dashboard'[PRIME_PASS]),SUM('mqsprod global_dashboard'[PRIME_TOTAL]),BLANK())

The tricky part now is to calculate rolling first pass yield, the calculation is simple per process you calculate Yield, and multiply it with the next process.

RFPY is: 90% x 90% x 90% x 90% x 90% = 59%.

What I want my users to do is to select a dashboard using a slicer.

This will give them the correct processes to multiply yield by.

But how can I get this realized?

[ZebraMK · Accepted solution]

We have resolved this problem by using:

RFTY = PRODUCTX(KEEPFILTERS(VALUES('mqsprod global_dashboard'[PROCESS])), CALCULATE([FPY]))

[Anonymous]

Hi @ZebraMK ，

It's glad to hear that your problem has been resolved. And thanks for sharing your solution, it will help others in the community if they face the similar problem with you. Could you please mark your last post as Answered since it has been resolved? Thank you.

Best Regards

Rena

[Anonymous]

Hi @ZebraMK ,

Could you please provide some sample data of table 'mqsprod global_dashboard' (exclude sensitive data)and the expected result with examples? Also could you please explain the calculation logic of RFPY? Is this a cumulative multiplication? How to determine the number of multipliers?

The tricky part now is to calculate rolling first pass yield, the calculation is simple per process you calculate Yield, and multiply it with the next process.

RFPY is: 90% x 90% x 90% x 90% x 90% = 59%.

---

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.