RevenuePivotedSimple =
CALCULATE
(
[TotalRevenue],
TREATAS
(
VALUES
(
PivotValues1[PDC Key]
)
, Fact_sales[ProductID]
)
,
TREATAS
(
VALUES
(
PivotValues2[PDC Key]
)
, Fact_sales[ProductID]
)
)