Forum Discussion

Diane_Gribi's avatar
Diane_Gribi
Icon for Helper I rankHelper I
3 years ago
Solved

Calculating FPU using distinct counts

DateInspectStageMOPlant NumberProductFault CodeWeek NumMonth QtrYear
01/01/01Test100111ABC100Product APass1JanQ101
02/01/01Test100112ABC101Product AInc Wiring1JanQ101
02/01/01Test100112ABC101Product AFluid Leak1JanQ101
02/01/01Test100113XYZ100Product BPass1JanQ101
02/01/01Test100114XYZ101Product BFluid Leak1JanQ101
02/01/01Test100114XYZ101Product BInc Wiring1JanQ101
08/01/01Test100115ABC102Product AFluid Leak2JanQ101
08/01/01Test100115ABC102Product AFluid Leak2JanQ101
09/01/01Test100116XZY102Product B

Pass

2JanQ101

 

Hi - Here is the table.  What I am looking to calculate is - 

By Week, Month, Qtr and Year

1) Qty of Fails (anything that doesn't have pass in the fault code field)

2) Qty Units that have fails

3) Qty Unit with 0 faults (Any line that has pass in the fault code field)

4) FPU (No of fails/Total Qty Units (qty unit with fails + qty unit with 0 fails))

5) FPY (No of units with 0 fails/Total Qty Units (qty unit with fails + qty unit with 0 fails))

I have a reasonable handle on calculating 1, 2 (using the MO number with a distinct count) and 3 but these are in different visuals.  I am struggling to get it to calculate 4 and 5 as I cant get the DAX code or calculation to add a criteria into my distinct count to only count the MO's with a pass + MO's without stating pass

When I try to do in the same visual the table counts the fail lines as a fail.

 

I am looking to create a visual that shows the following - 

ProductQty FailsQty Units with FailsQty Units with no failsFPU (Fails/(units with fails + units with no fails)FPY (Qty units with no fails/(units with fails + units with no fails) 
Product A4211.3333% 
Product B2120.6666% 

4 Replies