Question 1

How can the SELECTEDVALUE function be used to return a default value when no item is selected in a slicer?

Accepted Answer

Use SELECTEDVALUE(column, "Default") to return "Default" when no value is selected.

Answer

Use SELECTEDVALUE(column) without a default argument.

Answer

Default value cannot be set with SELECTEDVALUE.

Answer

Use IF(ISBLANK(SELECTEDVALUE(column)), "Default").

Question 2

When using the SWITCH function to create a dynamic title based on slicer selection, which of the following is necessary?

Accepted Answer

SELECTEDVALUE must be used within the SWITCH function to identify the selected slicer value.

Answer

Dynamic titles should be managed with calculated columns only.

Answer

IF statements should be used instead of SWITCH for dynamic titles.

Answer

The title should be hardcoded and cannot be dynamic.

Question 3

In a scenario where you want to display different measures based on a slicer selection, what combination of functions would you use?

Accepted Answer

Use SWITCH(TRUE(), SELECTEDVALUE(slicer) = "Option1", Measure1, SELECTEDVALUE(slicer) = "Option2", Measure2)

Answer

Use multiple IF statements without SELECTEDVALUE.

Answer

Use IFERROR to handle the selection logic.

Answer

Use SUMMARIZE and CALCULATE instead of SWITCH.

Question 4

What happens if SELECTEDVALUE is used in a report with multiple selections in the slicer?

Accepted Answer

It returns BLANK() unless a default value is specified.

Answer

It concatenates the selected values.

Answer

It returns the first selected value.

Answer

It generates an error.

Question 5

In a financial report, how would you show different currencies based on a user’s slicer selection using SWITCH and SELECTEDVALUE?

Accepted Answer

Use SWITCH(TRUE(), SELECTEDVALUE(currency_slicer) = "USD", [USD Measure], SELECTEDVALUE(currency_slicer) = "EUR", [EUR Measure]).

Answer

Use LOOKUPVALUE for each currency scenario.

Answer

Use CALCULATE(SUM(currency_slicer)).

Answer

Use IF(currency_slicer = "USD", [USD Measure], [EUR Measure]).

Question 6

How can the SELECTEDVALUE function be applied in a dynamic label that changes based on the slicer selection?

Accepted Answer

Embed SELECTEDVALUE(slicer_column) within a text field to dynamically display the selected value.

Answer

Use IF statements outside of SELECTEDVALUE.

Answer

Dynamic labels should be managed with data categories, not DAX functions.

Answer

Use CONCATENATE and CALCULATE functions for dynamic labels.

Question 7

If a slicer allows for multiple selections, what modification should be made to use SELECTEDVALUE effectively?

Accepted Answer

Consider using VALUES or CONCATENATEX instead, as SELECTEDVALUE returns BLANK() with multiple selections.

Answer

Use SELECTEDVALUE with a default value to handle multiple selections.

Answer

Use IF statements to handle multiple selections.

Answer

No modification is necessary; SELECTEDVALUE handles multiple selections by default.

Question 8

How would you use the SWITCH function to apply different formatting rules based on a user's slicer selection?

Accepted Answer

Use SWITCH(TRUE(), SELECTEDVALUE(slicer) = "Option1", "Format1", SELECTEDVALUE(slicer) = "Option2", "Format2").

Answer

Use IF statements with CALCULATE.

Answer

Apply formatting directly in the visual settings.

Answer

Use conditional formatting rules outside of the DAX measure.

Question 9

When using SELECTEDVALUE in a report with a hierarchical slicer, what should be considered?

Accepted Answer

SELECTEDVALUE will only return a value for the lowest level of the hierarchy.

Answer

SELECTEDVALUE can return all levels of the hierarchy.

Answer

SELECTEDVALUE cannot be used with hierarchical slicers.

Answer

Hierarchical slicers require CONCATENATEX to display all selections.

Question 10

How can you create a dynamic measure that changes based on user selections in multiple slicers using SWITCH and SELECTEDVALUE?

Accepted Answer

Nest multiple SWITCH functions, each using SELECTEDVALUE for the relevant slicer.

Answer

Create separate measures for each slicer scenario without using SWITCH.

Answer

Combine UNION and INTERSECT for slicer handling.

Answer

Use IF and CALCULATE together instead of SWITCH.

Related quizzes

Related quizzes