dax and Workspace Flashcards
You plan to create A power BI Workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose sharePoint document library is available to worksapce users once the workspace is created
Which setting should you configure when creating the workspace?
Workspace OneDrive
You Manage a Power BI workspace
You need to delegat the task to schedule data refreshes. The solution must use the principle of least privilege
Which role should you use
Contributor
You need to add an analytical line to a visual. The value for the line must equal the result of a DAX measure
That always return a consitent single value
The DAX measure must only be used to Populate the analytical line
Which type of analytical line shoud you use
Constant line
You need to develop a quick measure in Power BI desktop
Which two elements can you use
Calculation
Fields
In power BI desktop, you need to create a measure
Which two interefaces do you use
Data view
Report View
You need to ensure that the current inventory count returns only the current total number of inventory items, rather than the sum of all inventoyr items that includes items form previpis days
Last date
You have a Power BI desktop model
You need to determine when to use implicit and explicit measures
What is a feature of an implicit measure that explicit measure does NOT have
End users can change the aggregation type pf an implicit measure from the values well of a visual
You decide to start using variables when creatin Dax formulas
What are two benefits of usin variables in DAX measure over usin original expressions?
improves the overal performance of the resulting DAX measure
Improves the overal readability of the resultin DAX measure
You are creating a report in a Power BI desktop by usin a dataset that contains the sale data
You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year slected in any visual in the same report
Calculate
