Sales Fact
Date Table
Order Date (Active)
Ship Date (Inactive)
Goal: Calculate Sales by Ship Date.
We must override the default relationship to use the dotted line.
Ready...
💻 DAX Formula
-- Scenario 1: Default (Uses Active Path)
MEASURE Sales = SUM( Sales[Amount] )
-- Scenario 2: Activate the Inactive Path
MEASURE Sales_Shipped =
CALCULATE(
SUM( Sales[Amount] ),
USERELATIONSHIP(
Sales[ShipDate], 'Date'[Date]
)
)