DA-100: Analyzing Data with Microsoft Power BI

You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.

The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.

You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.

How should you complete the calculation? To answer, drag the appropriate values to the correct 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.

Correct answer: To work with this question, an Exam Simulator is required.

Explanation:

Box 1: CALCULATE -CALCULATE rvaluates an expression in a modified filter context.Box 2: DIVIDE -As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/- forward slash).When using the DIVIDE function, you must pass in numerator and denominator expressions.Box 3: ALLSELECTED -ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.Example:measure 'Reseller Sales'[Reseller Visual Total]=calculate(sum('Reseller Sales'[Sales Amount]), ALLSELECTED())Reference:https://docs.microsoft.com/en-us/dax/allselected-function-dax

Box 1: CALCULATE -

CALCULATE rvaluates an expression in a modified filter context.

Box 2: DIVIDE -

As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/

- forward slash).

When using the DIVIDE function, you must pass in numerator and denominator expressions.

Box 3: ALLSELECTED -

ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.

Example:

measure 'Reseller Sales'[Reseller Visual Total]=calculate(sum('Reseller Sales'[Sales Amount]), ALLSELECTED())

Reference:

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

You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.

You need to build the dashboard.

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.

Correct answer: To work with this question, an Exam Simulator is required.

Explanation:

When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.Step 1: Open the Dashboard.Step 2: Change the dashboard view to Phone viewStep 3: Pin items from the reports to the dashboard.Step 4: Rearrange, resize, or remote items from the Phone view.Create a phone view of a dashboard1. In the Power BI service, open a dashboard (Step 1)2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step 2) The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn't change.3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile.The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.4. If you change your mind, select Reset tiles to put them back in the size and order they were before.5. When you're satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view.Power BI saves the phone layout automatically.Reference:https://docs.microsoft.com/en-us/power-bi/create-reports/service-create-dashboard-mobile-phone-view

When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.

Step 1: Open the Dashboard.

Step 2: Change the dashboard view to Phone view

Step 3: Pin items from the reports to the dashboard.

Step 4: Rearrange, resize, or remote items from the Phone view.

Create a phone view of a dashboard

1. In the Power BI service, open a dashboard (Step 1)

2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step 2)

The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn't change.

3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile.

The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.

4. If you change your mind, select Reset tiles to put them back in the size and order they were before.

5. When you're satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view.

Power BI saves the phone layout automatically.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-create-dashboard-mobile-phone-view

Your company has employees in 10 states.

The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region information.

You have a report that shows the employees by state.

You need to view the employees by region as quickly as possible.

What should you do?

Create a new aggregation that summarizes by employee.
Create a new group on the state column and set the Group type to List.
Create a new group on the state column and set the Group type to Bin.
Create a new aggregation that summarizes by state.

Correct answer: B

Explanation:

B: 4 - Mosted

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and

Orders and between City and Orders.

The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.

City[State Province] = "Kentucky"

Role2 contains the following filter.

Date[Calendar Year] = 2020 -

If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
The user will see only data for which the State Province value is Kentucky.
The user will receive an error and will not be able to see the data in the report.

Correct answer: B

Explanation:

A: 1B: 5 - Mosted

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
Duplicate the Date query in Power Query and use active relationships between both Date tables.
On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Correct answer: C

Explanation:

C: 7 - MostedD: 6

Vendor:	Microsoft
Exam Code:	DA-100
Exam Name:	Analyzing Data with Microsoft Power BI
Date:	Oct 02, 2025
File Size:	7 MB

Download Analyzing Data with Microsoft Power BI.DA-100.ExamTopics.2025-10-02.94q.tqb

How to open TQB files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

ProfExam at a 20% markdown