edge
Generated by tmdl-lens
Overview
| Property | Value |
|---|
| Culture | - |
| Compatibility Level | - |
| Data Source Version | - |
1. Data Sources
This model contains 2 loaded tables, 3 measures, 1 relationship.
| Table | Source Type | Source |
|---|
Sales | Web API | Web API -> https://example.com/api/sales |
Lookup (hidden) | SQL | SQL -> srv -> db |
Not Loaded
None.
2. Table Details
Sales
Source: Web API
URL: https://example.com/api/sales
Columns
| Column | Type | Format | Summarize By | Source Column | Sort By | Description | Hidden |
|---|
Key | Integer | - | none | - | - | - | |
Date | Date/Time | yyyy-mm-dd | - | - | - | - | |
Amount | Decimal | #,0.00 | - | - | - | - | |
Key Column: Key
Measures
| Measure | Format | Description | Hidden |
|---|
Margin | 0.0% | - | |
Units | - | - | |
Plain | - | - | |
Margin
SUM(Sales[Amount]) * 0.1
Units
COUNTROWS(Sales)
Plain
1
Lookup
Source: SQL
Server: srv
Database: db
Hidden: Yes
Columns
| Column | Type | Format | Summarize By | Source Column | Sort By | Description | Hidden |
|---|
Key | Integer | - | - | - | - | - | |
Column Format Strings (4 total, 3 unique)
| Format String | Count | Columns |
|---|
| (none) | 2 | Key (Sales), Key (Lookup) |
yyyy-mm-dd | 1 | Date (Sales) |
#,0.00 | 1 | Amount (Sales) |
3. Measures
Finance\Margins
| Measure | Table | Format | Description |
|---|
Margin | Sales | 0.0% | - |
Margin
SUM(Sales[Amount]) * 0.1
General
| Measure | Table | Format | Description |
|---|
Plain | Sales | - | - |
Plain
1
Volume
| Measure | Table | Format | Description |
|---|
Units | Sales | - | - |
Units
COUNTROWS(Sales)
Measure Format Strings (3 total, 2 unique)
| Format String | Count | Measures |
|---|
| (none) | 2 | Units (Sales), Plain (Sales) |
0.0% | 1 | Margin (Sales) |
4. Functions
No user-defined functions defined.
5. Relationships
| From Table | From Column | To Table | To Column | Cardinality | Cross Filter | Security Filter |
|---|
Sales | Key | Lookup | Key | manyToOne | oneDirection | oneDirection |
6. Security Roles
No security roles defined.
7. M Parameters
| Parameter | Type | Value | Used By |
|---|
BlankParam | Text | - | - |
Region | Text | EU | - |
Only direct parameter references in connector calls are shown. Parameters used in conditional logic or computed expressions may not appear here.
8. Model Statistics
| Category | Count | Items |
|---|
| Loaded Tables | 2 | Sales, Lookup |
| Hidden Tables | 1 | Lookup |
| Calculated Tables | 0 | - |
| Field Parameters | 0 | - |
| Measures-Only Tables | 0 | - |
| Calculation Groups | 0 | - |
| Not Loaded | 0 | - |
| Relationships | 1 | - |
| Measures | 3 | - |
| Calculated Columns | 0 | - |
| Columns | 4 | - |