QUESTION: 59 Exam Topic: Mix Questions

DRAG DROP (Drag and Drop is not supported)
You have a Power BI dataset that contains the following measures:

-Budget
-Actuals
-Forecast

You create a report that contains 10 visuals.

You need provide users with the ability to use a slicer to switch between the measures in two visuals only.

You create a dedicated measure named CG Measure Switch.

How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: SELECTEDMEASURENAME()
SELECTEDMEASURENAME is used by expressions for calculation items to determine the measure that is in context by name.
Syntax: SELECTEDMEASURENAME()
No parameters.

Example:
The following calculation item expression checks if the current measure is Expense Ratio and conditionally applies calculation logic. Since the check is based on a string comparison, it is not subject to formula fixup and will not benefit from object renaming being automatically reflected. For a similar comparison that would benefit from formula fixup, please see the ISSLECTEDMEASURE function instead.

IF (
SELECTEDMEASURENAME = "Expense Ratio",
SELECTEDMEASURE (),
DIVIDE ( SELECTEDMEASURE (), COUNTROWS ( DimDate ) )
)

Incorrect:
* SELECTEDMEASURE is used by expressions for calculation items to reference the measure that is in context.
Syntax: SELECTEDMEASURE()
Can only be referenced in the expression for a calculation item.

* ISSELECTEDMEASURE is used by expressions for calculation items to determine the measure that is in context is one of those specified in a list of measures.

Syntax: ISSELECTEDMEASURE( M1, M2, ... )
Power BI dataset DAX slicer ISSELECTEDMEASURE

Box 2: SELECTEDVALUE()
SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

Syntax:
SELECTEDVALUE(<columnName>[, <alternateResult>])
M1, M2, ... - A list of measures.

Reference:

https://docs.microsoft.com/en-us/dax/selectedmeasurename-function-dax
https://docs.microsoft.com/en-us/dax/selectedvalue-function

Reveal Solution Next Question

QUESTION: 60 Exam Topic: Mix Questions

HOTSPOT (Drag and Drop is not supported)
You are configuring an aggregation table as shown in the following exhibit.

The detail table is named FactSales and the aggregation table is named FactSales(Agg).

You need to aggregate SalesAmount for each store.

Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Sum
The Manage aggregations dialog shows a row for each column in the table, where you can specify the aggregation behavior. In the following example, queries to the Sales detail table are internally redirected to the Sales Agg aggregation table.

Box 2: GroupBy

Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced

Reveal Solution Next Question

QUESTION: 61 Exam Topic: Mix Questions

You have a Power BI dataset that uses DirectQuery against an Azure SQL database.

Multiple reports use the dataset.

A database administrator reports that too many queries are being sent from Power BI to the database.

You need to reduce the number of queries sent to the database. The solution must meet the following requirements:

-DirectQuery must continue to be used.
-Visual interactions in all the reports must remain as they are configured currently.
-Consumers of the reports must only be allowed to apply filters from the Filter pane.

Which two settings should you select? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Add a single Apply button to the filter pane to apply changes at once
Add Apply buttons to all basic filters to apply changes when you’re ready
Disabling cross highlighting/filtering by default
Ignore the Privacy Levels and potentially improve performance
Add an Apply button to each slicer to apply changes when you’re ready

Answer(s): A,E

Explanation:

Reduce queries

Reduce the number of queries sent by Power BI using the Query reduction settings. For slicers, select the “Add an Apply button to each slicer to apply changes when you’re ready” option. For filters, select “Add a single Apply button to the filter pane to apply changes at once (preview).”

Incorrect:
Not C: Visual interactions in all the reports must remain as they are configured currently.
Otherwise: Remove unnecessary interactions between visuals

By default, all visuals on a report page can interact with one another. By disabling unnecessary interactions, you reduce the number of queries fired at the back end, which improves report performance.

Reference:

https://maqsoftware.com/insights/power-bi-best-practices

Reveal Solution Next Question

QUESTION: 62 Exam Topic: Mix Questions

DRAG DROP (Drag and Drop is not supported)
You have a Power BI dataset that contains two tables named Table1 and Table2. The dataset is used by one report.

You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Step 1: From Power BI Desktop, create a role named Project Managers.
Create roles
You can define roles within Power BI Desktop.

Step 2: Open Tabular Editor
Under Tables, select the table to which you want to apply a DAX rule.

In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”.

Step 3: From Power BI Desktop, add a DAX filter to the Project Managers role.

Step 4: For Table1, the Budget and Forecast columns, set the permissions to None.

Reference:

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

Reveal Solution Next Question

Free DP-500 Exam Braindumps (page: 22)

QUESTION: 59 Exam Topic: Mix Questions

Explanation:

Reference:

QUESTION: 60 Exam Topic: Mix Questions

Explanation:

Reference:

QUESTION: 61 Exam Topic: Mix Questions

Explanation:

Reference:

QUESTION: 62 Exam Topic: Mix Questions

Explanation:

Reference: