RevenuePivotedMultyDimension =
VAR FirstDimension =
SELECTEDVALUE ( PivotValues1[Dimension], "1" )
VAR SecondDimension =
SELECTEDVALUE ( PivotValues2[Dimension], "1" )
RETURN
SWITCH (
FirstDimension & SecondDimension,
"11",
CALCULATE (
[TotalRevenue],
TREATAS ( VALUES ( PivotValues1[PDC Key] ), Fact_sales[ProductID] ),
TREATAS ( VALUES ( PivotValues2[PDC Key] ), Fact_sales[ProductID] )
),
"12",
CALCULATE (
[TotalRevenue],
TREATAS ( VALUES ( PivotValues1[PDC Key] ), Fact_sales[ProductID] ),
TREATAS ( VALUES ( PivotValues2[PDC Key] ), Fact_sales[Zip] )
),
"22",
CALCULATE (
[TotalRevenue],
TREATAS ( VALUES ( PivotValues1[PDC Key] ), Fact_sales[Zip] ),
TREATAS ( VALUES ( PivotValues2[PDC Key] ), Fact_sales[Zip] )
),
"21",
CALCULATE (
[TotalRevenue],
TREATAS ( VALUES ( PivotValues1[PDC Key] ), Fact_sales[Zip] ),
TREATAS ( VALUES ( PivotValues2[PDC Key] ), Fact_sales[ProductID] )
)
)