tmdl-lens-test-report

Overview

Property	Value
Owner	Report Owner
Team	BI Team
Refresh Schedule	Daily at 06:00 UTC
Culture	en-US
Compatibility Level	1605
Data Source Version	powerBI_V3

1. Data Sources

This model contains 3 loaded tables, 1 calculated table, 1 field parameter, 1 measures-only table, 1 calculation group, 1 not loaded, 7 measures, 3 relationships.

Table	Source Type	Source
dim-product	Power Platform Dataflow	source-dataflow-platform -> Power Platform Dataflow -> product_dim
fact-sales	Power BI Dataflow	source-dataflow-standard -> Power BI Dataflow -> sales_fact
helper-order-lookup (hidden)	SQL	source-sql-staging -> source-sql-direct -> SQL -> fake-server.database.windows.net -> SalesDB -> dbo.orders

Support Tables

Table	Type
_measures	Measures
cg-time-intelligence	Calculation Group
dim-date	Calculated (DAX)
param-metric-selector	Field Parameter

Not Loaded

Table	Source Type	Source
source-sql-staging	SQL	source-sql-direct -> SQL -> fake-server.database.windows.net -> SalesDB -> dbo.orders

Not Loaded Column Format Strings (3 total, 2 unique)

Format String	Count	Columns
(none)	2	status (source-sql-staging), internal_notes (source-sql-staging)
0	1	order_id (source-sql-staging)

2. Table Details

dim-product

Source: Power Platform Dataflow

Entity: product_dim

Chain: source-dataflow-platform -> Power Platform Dataflow -> product_dim

Columns

Column	Type	Format	Summarize By	Source Column	Sort By	Description	Hidden
product_id	Text	-	none	product_id	-	Unique identifier for the product, sourced from the product dimension feed
product_name	Text	-	none	product_name	-	-
category	Text	-	none	category	-	Product category grouping used for merchandising reports
unit_price	Decimal	-	sum	unit_price	-	-
product_url	Text	-	none	product_url	-	-

Data Categories: product_url = WebURL

fact-sales

Source: Power BI Dataflow

Entity: sales_fact

Chain: source-dataflow-standard -> Power BI Dataflow -> sales_fact

Columns

Column	Type	Format	Summarize By	Source Column	Sort By	Description	Hidden
order_id	Integer	0	none	order_id	-	-
customer_id	Text	-	none	customer_id	-	-
order_date	Date/Time	Long Date	none	order_date	-	-
ship_date	Date/Time	Long Date	none	ship_date	-	-
amount	Decimal	-	sum	amount	-	-

Measures

Measure	Format	Description	Hidden
_Row Count Helper	#,##0	-	Hidden
Order Fulfillment Summary	0	-

_Row Count Helper

COUNTROWS('fact-sales')

Order Fulfillment Summary

[Open Order Count] & " open, status: " & SELECTEDVALUE('helper-order-lookup'[status_code])

⚠ References hidden: helper-order-lookup[status_code] (in helper-order-lookup), [Open Order Count] (in helper-order-lookup)

helper-order-lookup

Source: SQL

Table: dbo.orders

Physical table: dbo.orders

Server: fake-server.database.windows.net

Database: SalesDB

Chain: source-sql-staging -> source-sql-direct -> SQL -> fake-server.database.windows.net -> SalesDB -> dbo.orders

Hidden: Yes

Columns

Column	Type	Format	Summarize By	Source Column	Sort By	Description	Hidden
order_id	Integer	0	none	order_id	-	-
status_code	Text	-	none	status	-	-

Measures

Measure	Format	Description	Hidden
Open Order Count	0	-

Open Order Count

COUNTROWS('helper-order-lookup')

cg-time-intelligence

Columns

Column	Type	Format	Summarize By	Source Column	Sort By	Description	Hidden
Name	Text	-	-	Name	Ordinal	-
Ordinal	Integer	-	-	Ordinal	-	-

Calculation Items

Item	Ordinal	Format String
YTD	0	SELECTEDMEASUREFORMATSTRING()
MTD	1	SELECTEDMEASUREFORMATSTRING()
Rolling 12M	2	SELECTEDMEASUREFORMATSTRING()
Prior Year	3	SELECTEDMEASUREFORMATSTRING()
YoY %	4	0.00%

Calculation items can be applied to any measure at report-build time (via SELECTEDMEASURE()). TMDL has no static record of which measures a given item is actually used with.

YTD

TOTALYTD(SELECTEDMEASURE(), 'dim-date'[Date])

MTD

TOTALMTD(SELECTEDMEASURE(), 'dim-date'[Date])

Rolling 12M

CALCULATE(
    SELECTEDMEASURE(),
    DATESINPERIOD('dim-date'[Date], LASTDATE('dim-date'[Date]), -12, MONTH)
)

Prior Year

CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR('dim-date'[Date]))

YoY %

DIVIDE(
    SELECTEDMEASURE() - CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR('dim-date'[Date])),
    CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR('dim-date'[Date]))
)

dim-date

Source: Calculated (DAX)

CALENDARAUTO()

Columns

Column	Type	Format	Summarize By	Source Column	Sort By	Description	Hidden
Date	Date/Time	Long Date	none	Date	-	-
Year	Integer	0	none	Year	-	-
MonthName	Text	-	none	MonthName	MonthNumber	-
MonthNumber	Integer	0	none	MonthNumber	-	-

Key Column: Date

Calculated Columns

IsWeekend

WEEKDAY('dim-date'[Date], 2) > 5

PriorYearFlag

IF(
				YEAR('dim-date'[Date]) = YEAR(TODAY()) - 1,
				TRUE(),
				FALSE()
			)

param-metric-selector

Source: Field Parameter

Columns

Column	Type	Format	Summarize By	Source Column	Sort By	Description	Hidden
param-metric-selector	-	-	none	[Value1]	param-metric-selector Order	-
param-metric-selector Fields	-	-	none	[Value2]	-	-	Hidden
param-metric-selector Order	-	0	sum	[Value3]	-	-	Hidden

Column Format Strings (23 total, 3 unique)

Format String	Count	Columns
(none)	15	product_id (dim-product), product_name (dim-product), category (dim-product), unit_price (dim-product), product_url (dim-product), customer_id (fact-sales), amount (fact-sales), status_code (helper-order-lookup), Name (cg-time-intelligence), Ordinal (cg-time-intelligence), MonthName (dim-date), IsWeekend (dim-date), PriorYearFlag (dim-date), param-metric-selector (param-metric-selector), param-metric-selector Fields (param-metric-selector)
0	5	order_id (fact-sales), order_id (helper-order-lookup), Year (dim-date), MonthNumber (dim-date), param-metric-selector Order (param-metric-selector)
Long Date	3	order_date (fact-sales), ship_date (fact-sales), Date (dim-date)

3. Measures

General

Measure	Table	Format	Description
Total Sales Amount	_measures	#,##0.00	-
Order Count	_measures	#,##0	-
Avg Order Value	_measures	#,##0.00	-
Sales YTD	_measures	#,##0.00	-
_Row Count Helper	fact-sales	#,##0	-
Order Fulfillment Summary	fact-sales	0	-
Open Order Count	helper-order-lookup	0	-

Total Sales Amount

SUM('fact-sales'[amount])

Order Count

DISTINCTCOUNT('fact-sales'[order_id])

Avg Order Value

DIVIDE([Total Sales Amount], [Order Count], 0)

Sales YTD

TOTALYTD([Total Sales Amount], 'dim-date'[Date])

_Row Count Helper

COUNTROWS('fact-sales')

Order Fulfillment Summary

[Open Order Count] & " open, status: " & SELECTEDVALUE('helper-order-lookup'[status_code])

Open Order Count

COUNTROWS('helper-order-lookup')

Measure Format Strings (7 total, 3 unique)

Format String	Count	Measures
#,##0.00	3	Total Sales Amount (_measures), Avg Order Value (_measures), Sales YTD (_measures)
#,##0	2	Order Count (_measures), _Row Count Helper (fact-sales)
0	2	Order Fulfillment Summary (fact-sales), Open Order Count (helper-order-lookup)

4. Functions

Function	Used By	Description
AddTax	-	Adds sales tax to a net amount using the given rate.
SafeStockThreshold	-	Returns the reorder threshold for a product category.

AddTax

(amount: number, rate: number) => amount * (1 + rate)

SafeStockThreshold

(category: string) =>
		IF(category == "Hardware", 50, 20)

5. Relationships

From Table	From Column	To Table	To Column	Cardinality	Cross Filter	Security Filter
fact-sales	order_date	dim-date	Date	Many-to-One	bothDirections	oneDirection
fact-sales	customer_id	dim-product	product_id	Many-to-One	oneDirection	oneDirection

Inactive Relationships

From Table	From Column	To Table	To Column	Cross Filter	Security Filter
fact-sales	ship_date	dim-date	Date	oneDirection	bothDirections

6. Security Roles

Role	Table	Filter	Dynamic
Administrators	-	-	No
Area Supervisors	fact-sales	[region] = "South"	No
	dim-product	[category] = "Hardware"
Employees	dim-product	USERPRINCIPALNAME() = [email]	Yes (USERPRINCIPALNAME)
Legacy Users	dim-product	USERNAME() = [username]	Yes (USERNAME)
Regional Managers	fact-sales	[region] = "North"	No

7. M Parameters

Parameter	Type	Value	Used By
ServerName	Text	fake-server.database.windows.net	source-from-parameter
DatabaseName	Text	SalesDB	source-from-parameter

Only direct parameter references in connector calls are shown. Parameters used in conditional logic or computed expressions may not appear here.

⚠ Unresolved Sources

The following sources could not be resolved statically.

Expression	Reason
source-via-custom-function	no connector, combine or query reference found

8. Model Statistics

Category	Count	Items
Loaded Tables	3	dim-product, fact-sales, helper-order-lookup
Hidden Tables	1	helper-order-lookup
Calculated Tables	1	dim-date
Field Parameters	1	param-metric-selector
Measures-Only Tables	1	_measures
Calculation Groups	1	cg-time-intelligence
Not Loaded	1	source-sql-staging
Relationships	3	-
Measures	7	-
Calculated Columns	2	-
Columns	12	-