interview Question on DAX- SUMX

[naveenskyline]

Hi ALL,

I have this question in a recent interview and want to check with you the correct DAX.

 Question was to write a DAX using SUMX - Assume we have multiple measures(Profit, Sales,..) and 2 dimemsions (Products,Regions). If we select profit , it should display only profit numbers for products and Regions, Similarly If we select Sales , it should display only Sales numbers for products and Regions,

Please help with the DAX.

@jennratten 

[Shravan133 · Accepted solution]

-- Slicer Table
SlicerTable =
DATATABLE(
"MeasureName",
STRING,
{
{"Profit"},
{"Sales"}
}
)

-- Measures
Profit = SUM('FactTable'[Profit])
Sales = SUM('FactTable'[Sales])

-- Dynamic Measure
SelectedMeasure =
VAR SelectedValue = SELECTEDVALUE('SlicerTable'[MeasureName])
RETURN
SWITCH(
TRUE(),
SelectedValue = "Profit", [Profit],
SelectedValue = "Sales", [Sales]
)

-- Display Measure
DisplayMeasure =
SUMX(
VALUES('DimensionTable'[Product]),
[SelectedMeasure]
)