Total Sales Measure₹66,000SUM(Sales[Revenue])
Profit Margin %37%₹24,200 Gross Profit
Distinct Customers4DISTINCTCOUNT(CustID)
Model IntegrityInflated by Fan-Out₹66,000 vs expected ₹45,000
1. Semantic Model Relationship Canvas
customers (5 rows)
sales (5 rows)
products (3 rows)
Duplicate keys detected in the customer dimension. A "raw" (many-to-many) relationship will fan out and inflate revenue.
Customers → Sales Key
Products → Sales Key
Cross-Filtering Segment Slicer:
Sales Fact Table (7 joined rows)
| Order | Customer | Segment | Product | Revenue | Cost |
|---|---|---|---|---|---|
| S-01 | Nexus Retail | Enterprise | Widget Pro | ₹12,000 | ₹8,000 |
| S-01 | Nexus Retail | Enterprise | Widget Pro | ₹12,000 | ₹8,000 |
| S-02 | Bright Mart | Mid-Market | Widget Lite | ₹5,000 | ₹3,500 |
| S-03 | Nexus Retail | Enterprise | Widget Max | ₹9,000 | ₹5,000 |
| S-03 | Nexus Retail | Enterprise | Widget Max | ₹9,000 | ₹5,000 |
| S-04 | Orbit Traders | Enterprise | Widget Pro | ₹15,000 | ₹9,500 |
| S-05 | Fern SMB Co | SMB | Widget Lite | ₹4,000 | ₹2,800 |
2. Measure Template Builder
Revenue by Segment
Revenue Share by Product
₹66,000Total
History step 0 · BI concepts simulator — not a Power BI embed, DAX execution engine or PBIX export.
1. Validity
Inputs Supported
All configuration parameters are valid.
2. Correctness
Objective: Demonstrated
Ready for verification run
3. Constraints
Within Limits
Budget, SLA, and capacity limits respected.
4. Trade-offs
Analysis
Inspect scenario parameters to evaluate trade-offs.