Supplier ScorecardSemantic Model Synthetic sample model
Click a definition to edit · Ctrl+S to save
9
Tables
58
Columns
23
Measures
6
Relationships
15
Simple
8
Moderate
0
Complex

Measures

Measure Format Hidden Complexity Reports Used Definition DAX
Measures
Avg Actual Lead Time Days #,0.0 No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Actual Lead Time Days])
Avg Actual Lead Time Label — No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
CONCATENATE(FORMAT([Avg Actual Lead Time Days], 0), " Days")
Avg Expected Lead Time Days #,0.0 No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Expected Lead Time Days])
Avg Expected Lead Time Label — No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
CONCATENATE(FORMAT([Avg Expected Lead Time Days], 0), " Days")
Avg Requested Lead Time Days #,0.0 No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Requested Lead Time Days])
Avg Requested Lead Time Label — No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
CONCATENATE(FORMAT([Avg Requested Lead Time Days], 0), " Days")
Count NCR 0 No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
    SUMX(
        SUMMARIZE('PO NCR Bridge', 'PO NCR Bridge'[PO Line Key], "Count NCR", IF(DISTINCTCOUNT('PO NCR Bridge'[NCR ID]) >= 1, 1, BLANK())),
        [Count NCR]
    )
Count PO #,0 No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
DISTINCTCOUNT('PO'[PO Line Key])
Overall Score 0.0 No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
(20 * [Pct On Time])
+ (20 * [Pct In Full])
+ (30 * [Pct Lead Time Accuracy])
+ (30 * [Pct NCR])
Overall Score Color — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
SWITCH(
    TRUE() ,
    [Overall Score] >= 95, "#438D32",
    [Overall Score] >= 85 && [Overall Score] < 95, "#7DDA58",
    [Overall Score] >= 70 && [Overall Score] < 85, "#FE9900",
    [Overall Score] < 70, "#E4080A"
    )
Overall Score Label — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX

Var Result = FORMAT([Overall Score], 0)

RETURN CONCATENATE(Result  , " out of 100")
Pct Avg OTIF 0.0%;-0.0%;0.0% No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Is Avg OTIF])
Pct In Full 0.0%;-0.0%;0.0% No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Is In Full])
Pct In Full Color — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
SWITCH(
    TRUE() ,
    [Pct In Full] >= .95, "#438D32",
    [Pct In Full] >= .85 && [Pct In Full] < .95, "#7DDA58",
    [Pct In Full] >= .70 && [Pct In Full] < .85, "#FE9900",
    [Pct In Full] < .70, "#E4080A"
    )
Pct Lead Time Accuracy 0.0%;-0.0%;0.0% No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[LTA])
Pct Lead Time Accuracy Color — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
SWITCH(
    TRUE(),
    [Pct Lead Time Accuracy] >= .95, "#438D32",
    [Pct Lead Time Accuracy] >= .85 && [Pct Lead Time Accuracy] < .95, "#7DDA58",
    [Pct Lead Time Accuracy] >= .70 && [Pct Lead Time Accuracy] < .85, "#FE9900",
    [Pct Lead Time Accuracy] < .70, "#E4080A"
)
Pct NCR 0.0%;-0.0%;0.0% No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
1 - DIVIDE([Count NCR], [Count PO])
Pct NCR Color — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
SWITCH(
    TRUE() ,
    [Pct NCR] >= .99, "#438D32",
    [Pct NCR] >= .98 && [Pct NCR] < .99, "#7DDA58",
    [Pct NCR] >= .97 && [Pct NCR] < .98, "#FE9900",
    [Pct NCR] < .97, "#E4080A"
    )
Pct NCR Tooltip — No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
"Percentage of PO lines with no NCR's"
Pct On Time 0.0%;-0.0%;0.0% No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Is On Time])
Pct On Time Color — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
SWITCH(
    TRUE() ,
    [Pct On Time] >= .95, "#438D32",
    [Pct On Time] >= .85 && [Pct On Time] < .95, "#7DDA58",
    [Pct On Time] >= .70 && [Pct On Time] < .85, "#FE9900",
    [Pct On Time] < .70, "#E4080A"
    )
Pct True OTIF 0.0%;-0.0%;0.0% No Simple Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
AVERAGE(PO[Is True OTIF])
Pct True OTIF Color — No Moderate Supplier Scorecard

Definition pending Data Governance review.

Draft — pending Data Governance review
View DAX
SWITCH(
    TRUE() ,
    [Pct True OTIF] >= .95, "#438D32",
    [Pct True OTIF] >= .85 && [Pct True OTIF] < .95, "#7DDA58",
    [Pct True OTIF] >= .70 && [Pct True OTIF] < .85, "#FE9900",
    [Pct True OTIF] < .70, "#E4080A"
    )

Relationships

From TableFrom Column To TableTo Column ActiveDirection
PO Vendor Account Number Vendor Vendor Account Number ✓ ↔ Both
PO Product Number Product Product Number ✓ ↔ Both
PO Purchase Order Date Date Date ✓ → Single
PO NCR Bridge PO Line Key PO PO Line Key ✓ → Single
PO NCR Bridge NCR ID NCR NCR ID ✓ → Single
PO Warehouse ID Warehouse Warehouse ID ✓ → Single

Tables

Last Refresh (hidden)

ColumnTypeHidden
Date Last Refreshed dateTime Yes

PO

ColumnTypeHidden
Purchase Order string No
Purchase Order Line int64 No
Purchase Order Type string No
Purchase Order Status string No
Vendor Account Number string Yes
Product Number string Yes
Purchase Order Date dateTime No
Confirmed Receipt Date dateTime No
Order Sent Date dateTime Yes
Order Quantity double Yes
Received Quantity double No
PO Line Key string Yes
PO Line Requested Receipt Date dateTime No
Contractual Receipt Date dateTime No
Contractutal Lead Time int64 No
Warehouse ID string Yes
Inventory Trx ID string No
PO UoM string No
Expected Receipt Date dateTime No

Date

ColumnTypeHidden
Date dateTime No
Month Number int64 Yes
Month Name string No
Month Short Name string No
Year Number int64 No
Year Filter string No
Include Date Flag string Yes

Product

ColumnTypeHidden
Product Number string No
Cost Group Description string No
Item Group Description string No
Product Description string No

Vendor

ColumnTypeHidden
Vendor Account Number string No
Vendor Name string No

Measure

ColumnTypeHidden
Dummy string Yes

PO NCR Bridge (hidden)

ColumnTypeHidden
PO Line Key string Yes
NCR ID string Yes

NCR

ColumnTypeHidden
NCR ID string No
Action ID int64 Yes
SubForm ID int64 No
SubTask ID int64 No
Action Category string No
Action Date dateTime No
Action Status string No
Quantity double No
UoM string No
Site string No
Department string No
Title string No
Memo string No
Reason string No
Root Cause string No
Action string No
SubForm Category string No
SubTask Category string No

Warehouse

ColumnTypeHidden
Warehouse ID string No
Warehouse Name string No
Warehouse string No
Warehouse ID Sort string Yes

Synthetic Supplier Scorecard demonstration