What it measures
% of total revenue from new product launches
it measures the revenue outcome of innovation decisions made 6-24 months prior. A low score confirms a past failure in the pipeline or launch execution; the commercial damage is already done.
Business impact
- Increased 'chaos tax' from inefficient, small-batch production runs for new products that steal finite labor or line capacity from profitable core SKUs, driving up the manufacturing cost per tonne.
Formula
(NPD revenue / Total revenue) x 100Grain
One row per billing document line — customer × product × plant × date
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Sales_Invoice_Line. It guards against missing dates and values with NOT ISBLANK checks.
Fact_Sales_Invoice_Line— 6 mandatory columns — product key, billing date key, ...Dim_Currency— currency_key + currency_codeDim_Customer— key + nameDim_Plant— key + nameDim_Product— key + nameDim_Date— Auto-generated calendar table — no customer data required
Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.
| Target | 0.2 — performance considered compliant at or above this line |
| Warning | 0.1 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Everything you need to build New Product Revenue Share in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.