Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
naveenskyline
Regular Visitor

interview Question on DAX- SUMX

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 

1 ACCEPTED SOLUTION
Shravan133
Solution Sage
Solution Sage

-- 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]
)

View solution in original post

1 REPLY 1
Shravan133
Solution Sage
Solution Sage

-- 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]
)

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.