1-331 of 331
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?
,___ (TOTAL SALES), _______ ([TOTAL SALES], _________ (PRODUCT [PRODUCTCATEGORYNAME])))
ALL
ALLSELECTED
CALCULATE
CURRENTGROUP
DIVIDE
SUMMARIZE
TOPN
Give this one a try later!
DIVIDE ([TOTAL SALES]
CALCULATE ([ TOTAL SALES], ALLSELECTED (PRODUCT[...)
You need to create a custom visualization for Power BI.
What should you install first?
jQuery
Node.js
Microsoft Azure PowerShell
Microsoft.NET
Give this one a try later!
, Node.js
What can the admin role do in a workspace?
Give this one a try later!
Update and delete workspace, add or remove anyone
From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error
Rate, and On-time Rate.
You add a button to the Main page for navigation.
You need to implement a solution that meets the following requirements:
The navigation destination must change based on the output of a DAX measure named [Error
Rate].
If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to the
Error Rate page.
Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate
page.
What three actions should you perform? Each correct answer presents part of the solution.
, Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
Set the button type to Page Navigation and then use conditional formatting to specify the
destination.
Set the button type to Bookmark and then use conditional formatting to specify the destination.
Set the navigation destination to the Error Rate page
.Use conditional formatting to set the button text.
Give this one a try later!
Create a DAX measure that outputs the correct page name based on the value of [Error
Rate]
Set the button type to Page Navigation and then use conditional formatting to specify
the destination
Use conditional formatting to set the button text
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the visualizations in the dashboard are updated daily.
Which three actions should you perform in sequence?
Download and install an on-premises data gateway (personal)
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?
,___ (TOTAL SALES), _______ ([TOTAL SALES], _________ (PRODUCT [PRODUCTCATEGORYNAME])))
ALL
ALLSELECTED
CALCULATE
CURRENTGROUP
DIVIDE
SUMMARIZE
TOPN
Give this one a try later!
DIVIDE ([TOTAL SALES]
CALCULATE ([ TOTAL SALES], ALLSELECTED (PRODUCT[...)
You need to create a custom visualization for Power BI.
What should you install first?
jQuery
Node.js
Microsoft Azure PowerShell
Microsoft.NET
Give this one a try later!
, Node.js
What can the admin role do in a workspace?
Give this one a try later!
Update and delete workspace, add or remove anyone
From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error
Rate, and On-time Rate.
You add a button to the Main page for navigation.
You need to implement a solution that meets the following requirements:
The navigation destination must change based on the output of a DAX measure named [Error
Rate].
If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to the
Error Rate page.
Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate
page.
What three actions should you perform? Each correct answer presents part of the solution.
, Create a DAX measure that outputs the correct page name based on the value of [Error Rate].
Set the button type to Page Navigation and then use conditional formatting to specify the
destination.
Set the button type to Bookmark and then use conditional formatting to specify the destination.
Set the navigation destination to the Error Rate page
.Use conditional formatting to set the button text.
Give this one a try later!
Create a DAX measure that outputs the correct page name based on the value of [Error
Rate]
Set the button type to Page Navigation and then use conditional formatting to specify
the destination
Use conditional formatting to set the button text
You have a Microsoft Excel workbook that contains two tables.
From Power BI, you create a dashboard that displays data from the tables.
You update the tables each day.
You need to ensure that the visualizations in the dashboard are updated daily.
Which three actions should you perform in sequence?
Download and install an on-premises data gateway (personal)
