PlantOps BI

Search

Every page on the site, 63 in all. Type to narrow the list; it searches titles, formulas, headings and text.

  1. KPI · Labor

    Absenteeism Rate

    Absenteeism rate definition and formula, why unplanned absences differ from PTO, realistic benchmarks by industry, and the Power BI DAX to track it by shift.

  2. KPI · Production

    Capacity Utilization

    Capacity utilization definition and formula, why running near 100% is a risk rather than a win, realistic benchmarks, and the Power BI DAX to calculate it.

  3. KPI · Production

    Cycle Time

    Cycle time definition and formula, realistic benchmarks against engineered ideal time, the gaming trap to watch for, and the Power BI DAX to track it.

  4. KPI · Inventory

    Inventory Days on Hand

    Days on hand definition and formula, realistic benchmarks by inventory type, why chasing it too hard causes stockouts, and the Power BI DAX to calculate it.

  5. KPI · Quality

    First Pass Yield (FPY)

    First pass yield (FPY) definition and formula, why it differs from rolled throughput yield, realistic benchmarks, and the Power BI DAX to calculate both.

  6. KPI · Financial

    4-Wall Margin

    4-wall margin definition and formula, why there's no external benchmark, the corporate-allocation fight to watch for, and the Power BI DAX to build it.

  7. KPI · Production

    Changeover Time (SMED)

    Changeover time definition and formula, realistic SMED benchmarks, the ramp-up trap that hides scrap, and the Power BI DAX to track it by line and part.

  8. KPI · Labor

    Labor Productivity

    Labor productivity definition and formula, why raw units per hour misleads across product mixes, the standard-hours fix, and the Power BI DAX to build it.

  9. KPI · Inventory

    Inventory Turns

    Inventory turns definition and formula, why average inventory beats a snapshot, realistic benchmarks by category, and the Power BI DAX to calculate turns.

  10. KPI · Production

    MTBF (Mean Time Between Failures)

    MTBF definition and formula, realistic benchmarks by asset type, why failure-definition drift inflates the number, and the Power BI DAX to calculate it.

  11. KPI · Production

    MTTR (Mean Time to Repair)

    MTTR definition and formula, realistic benchmarks, the clock-stopping trap that hides real downtime, and the Power BI DAX to build it from maintenance events.

  12. KPI · Production

    OEE (Overall Equipment Effectiveness)

    What OEE means, how to calculate Availability × Performance × Quality, realistic benchmarks by industry, and the DAX to build OEE in Power BI.

  13. KPI · Delivery

    On-Time Delivery (OTD)

    OTD definition and formula, why delivery date beats ship date, realistic benchmarks by industry, and the Power BI DAX to track on-time delivery weekly.

  14. KPI · Labor

    Overtime Percentage

    Overtime percentage definition and formula, realistic benchmarks, why plant-wide averages hide the real problem, and the Power BI DAX to track it by line.

  15. KPI · Delivery

    Past-Due Backlog

    Past-due backlog definition and formula, why there's no external benchmark, the date-creep trap that hides it, and the Power BI DAX to track it by order.

  16. KPI · Delivery

    OTIF (On Time in Full)

    OTIF definition and formula, how it differs from OTD and fill rate, realistic benchmarks and gaming risks, plus the Power BI DAX to measure it per order.

  17. KPI · Quality

    Defect PPM (Parts per Million)

    Defect PPM definition and formula, realistic benchmarks from automotive to general manufacturing, the undercounting trap, and the Power BI DAX to build it.

  18. KPI · Quality

    Scrap Rate

    Scrap rate definition and formula, realistic benchmarks by process maturity, the rework-reclassification trap, and the Power BI DAX to track units and cost.

  19. KPI · Production

    Schedule Attainment

    Schedule attainment definition and formula, why 85% is the common target, how it differs from OEE and utilization, plus the Power BI DAX to measure it weekly.

  20. KPI · Production

    Takt Time

    Takt time definition and formula, why it isn't a performance metric like cycle time, how to compare it to actual pace, and the Power BI DAX to calculate it.

  21. KPI · Safety

    TRIR (Total Recordable Incident Rate)

    TRIR definition and formula, why the 200,000-hour constant exists, honest benchmarks by industry, and the Power BI DAX to track it on a trailing basis.

  22. KPI · Production

    Unplanned Downtime %

    Unplanned downtime definition and formula, how it differs from OEE availability, realistic benchmarks, and the Power BI DAX to track it by reason code.

  23. Field Note

    Your Agent Transcripts May Be Deleted After 30 Days

    The default cleanup setting removed my personal agent history. What I changed, and the append-only backup and monthly restore drill I put behind it.

  24. Error guide

    Direct Lake Relationship Skipped Because the Key Column Is Double

    A fact table key landed in Delta as Double, so the relationship was skipped. How I changed the column type from TMDL view and got the relationship active.

  25. Error guide

    Fabric Git Says "Can't fetch branches": Check the Tenant Setting

    Connecting a workspace to GitHub failed on a new tenant until an admin enabled a tenant setting that is easy to miss.

  26. Error guide

    Direct Lake: "relationship needs to be recalculated" Is a Refresh You Forgot

    After adding relationships to a Direct Lake model, queries fail until you reframe the model with a refresh.

  27. Field Note

    Don't Accept 'Done' from an Agent Without a Quoted Source

    An agent's 'done' only tells you what it believes happened. The rule I enforce: no quote and source, no done, plus read-only review passes when being wrong is expensive.

  28. Error guide

    PBIR Report Won't Import into Fabric: Missing definition/version.json

    A generated PBIR report failed to import because definition/version.json and two report.json fields were missing. What each one needs to contain.

  29. Error guide

    A Freshly Git-Deployed Power BI Model Won't Refresh

    After deploying an import model from Git into Fabric, refresh does nothing until you set the data source credential and re-enable scheduled refresh.

  30. Error guide

    TMDL InvalidLineType: A Doc Comment Followed by a Blank Line

    In a TMDL file, /// doc comments followed by a blank line produce an InvalidLineType parse error. What to look for and what to change.

  31. Field Note

    Guard Rails for Agents That Work Near Production

    A guard hook, a kill switch, a headless launcher with caps, and a serial-only refresh rule: how I keep agents from doing damage in my home lab, and why to start in shadow mode.

  32. Field Note

    Routing Agent Work by Model Tier, and Red-Teaming My Own Automation

    A task router that sends each job to the smallest model that can close it, plus a red-team unit that found a code-execution hole in my self-updating routine.

  33. Error guide

    Notebook saveAsTable Fails: The Default Lakehouse Isn't Attached

    A Fabric notebook that writes Delta tables errors if you run it before attaching a lakehouse. The set-default option only appears after you add one.

  34. Error guide

    TMDL View: One Command per Apply

    Pasting 21 separate createOrReplace commands into TMDL view does not work. Put the relationships under one command.

  35. Error guide

    Fabric Git Deploy Fails with 'Unable to finish metadata synchronization'

    A shared M function expression in a TMDL model broke deployment from Git. Inlining the M into each partition fixed it.

  36. Field Note

    Context Transition, Explained with Three Bugs I Wrote

    Three real DAX mistakes from this site, each a different side of context transition and filter arguments, with the broken version, why it broke, and the fix.

  37. Field Note

    How This Site Tests Its Own DAX

    Every DAX block here is linted on each build, every analysis number is computed from the demo CSVs, and the tests check identities, not snapshots. What that caught.

  38. Field Note

    Review a Power BI Release Before It Ships

    A short release review for a semantic model saved as a TMDL project: compare it with production, read the checks, and keep a Markdown dictionary in git so the next diff is readable.

  39. Analysis

    OEE Across Lines

    How unit-pooled OEE drifts once lines with different ideal rates roll up, and DAX in ideal-rate minutes that adds up.

  40. Analysis

    Downtime Pareto

    Unplanned minutes by reason per plant, with cumulative-share DAX that survives slicers and ties.

  41. Analysis

    XmR Chart

    Process behavior limits from a fixed baseline, read honestly, with the DAX to draw them.

  42. Analysis

    Inventory Snapshots

    Closing balance and average stock from month-end snapshots, and why LASTNONBLANK by part ships wrong numbers.

  43. Analysis

    On-Time Shipping

    Why the newest month flatters, how to count overdue open lines, and what changes between order month and ship month.

  44. Analysis

    TRIR with Small Numbers

    Exact Poisson ranges for a rate built on a handful of incidents, a test for whether a drop is real, and CHISQ.INV in DAX.

  45. Analysis

    ISO Weeks

    Why calendar year plus ISO week corrupts every week-1 total, an ISO year column, and two honest ways to compare with last year.

  46. Analysis

    Price-Volume-Mix

    A revenue bridge from the demo orders, and why measuring at the wrong grain turns customer mix into a pricing win.

  47. Analysis

    ABC Classification

    Parts ranked by usage value, the stock and days of supply each class holds, and dynamic ABC segmentation in DAX that handles ties.

  48. Analysis

    Top N and Others

    Top customers plus one Others bar that adds up, handles ties and respects slicers, and the HHI as one number for concentration.

  49. Tool

    Model Documenter

    Word and Excel data dictionary of a Power BI semantic model, with DAX and model checks. Runs in the browser.

  50. Tool

    DAX Lint

    Check DAX measures for division without DIVIDE, IFERROR, FILTER over whole tables and more.

  51. Tool

    Process Behavior Chart

    Paste a KPI series and get XmR limits, signals and a chart.

  52. Tool

    Rate Comparison

    Exact Poisson ranges for two incident rates and a test of whether the change is real.

  53. Tool

    Model Compare

    Compare two versions of a semantic model: tables, columns, measures with a DAX diff, relationships and roles.

  54. Reference

    Check Rules

    Every DAX Lint and Model Documenter rule, what it flags and why.

  55. Tool

    Fiscal Calendar Generator

    4-4-5, 4-5-4 or 5-4-4 fiscal calendar as a DAX calculated table, with 53-week years shown.

  56. Tool

    KPI Calculators and DAX Generators

    Calculators that compare your number to a typical range, and DAX with your own table names.

  57. Data

    Demo Dataset

    A synthetic manufacturer in 13 CSV tables: profiles, bus matrix and key checks.

  58. Exercise

    Spot the Problem

    Charts that look right and are not, with the DAX that finds the problem.

  59. Guide

    Document the AdventureWorks Model

    A sample data dictionary from the Model Documenter.

  60. Library

    Manufacturing KPI Library

    Every KPI with its formula, typical range, DAX, calculator and generator.

  61. Library

    Field Notes

    Notes and error guides on running Power BI and Fabric.

  62. Page

    Home

    Free Power BI resources for manufacturing.

  63. Page

    About

    Who runs this site and why.