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.
Date | InspectStage | MO | Plant Number | Product | Fault Code | Week Num | Month | Qtr | Year |
01/01/01 | Test | 100111 | ABC100 | Product A | Pass | 1 | Jan | Q1 | 01 |
02/01/01 | Test | 100112 | ABC101 | Product A | Inc Wiring | 1 | Jan | Q1 | 01 |
02/01/01 | Test | 100112 | ABC101 | Product A | Fluid Leak | 1 | Jan | Q1 | 01 |
02/01/01 | Test | 100113 | XYZ100 | Product B | Pass | 1 | Jan | Q1 | 01 |
02/01/01 | Test | 100114 | XYZ101 | Product B | Fluid Leak | 1 | Jan | Q1 | 01 |
02/01/01 | Test | 100114 | XYZ101 | Product B | Inc Wiring | 1 | Jan | Q1 | 01 |
08/01/01 | Test | 100115 | ABC102 | Product A | Fluid Leak | 2 | Jan | Q1 | 01 |
08/01/01 | Test | 100115 | ABC102 | Product A | Fluid Leak | 2 | Jan | Q1 | 01 |
09/01/01 | Test | 100116 | XZY102 | Product B | Pass | 2 | Jan | Q1 | 01 |
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 -
Product | Qty Fails | Qty Units with Fails | Qty Units with no fails | FPU (Fails/(units with fails + units with no fails) | FPY (Qty units with no fails/(units with fails + units with no fails) | |
Product A | 4 | 2 | 1 | 1.33 | 33% | |
Product B | 2 | 1 | 2 | 0.66 | 66% |
Solved! Go to Solution.
Thanks. Is there a way to make the MO column the columns for counting distinct units based on having a fault or not?
Thanks you so much, I have spent weeks trying to solve this. It works as exactly as I need it to. I have accepted the solution above. Thanks again
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |