Day 14 - Power BI Challenge

1. What is the primary difference between an implicit measure and an explicit measure in Power BI?

• Implicit measures are user-defined, while explicit measures are system-generated.
• Implicit measures are automatically created for numeric fields, while explicit measures are defined by the user using DAX.
• Explicit measures are created in Power Query, while implicit measures are created in the Data Model.
• Implicit measures require DAX, while explicit measures do not.
• Explicit measures can only be used in calculated columns.

2. Which of the following is an example of an explicit measure in Power BI?

• A sum of sales automatically generated by Power BI.
• A DAX formula created by a user to calculate total sales.
• A column that multiplies price by quantity in Power Query.
• A text field that concatenates two strings.
• An automatically generated count of rows in a table.

3. What is the primary benefit of using dedicated measure tables in Power BI?

• It allows for improved query performance.
• It groups all measures in one place for better organization and clarity.
• It automatically calculates all measures on report load.
• It reduces the number of relationships in the data model.
• It allows for conditional formatting based on measures.

4. What is the filter context in Power BI DAX?

• The context created by filters and slicers applied to a visual or report page.
• The context used by Power Query to apply data transformations.
• The method used to join two tables in the data model.
• The way Power BI refreshes the dataset on a schedule.
• The process of creating relationships between tables.

5. Which feature allows you to quickly create a DAX measure without writing DAX code manually?

• Implicit Measures
• Quick Measures
• Explicit Measures
• Calculated Columns
• Measure Tables

6. What happens if you change the filter context in a DAX calculation using the CALCULATE() function?

• It changes the filter context for the entire report.
• It modifies the filter context only within the scope of that calculation.
• It removes all filters applied to the data model.
• It creates a new implicit measure.
• It disables all cross-filtering in the report.

7. Which DAX function can be used to apply a calculation to a different filter context without altering the existing filter context for other visuals?

• ALL()
• CALCULATE()
• REMOVEFILTERS()
• USERELATIONSHIP()
• ALLEXCEPT()

8. When would it be beneficial to create a dedicated measure table in Power BI?

• When your measures are causing performance issues.
• When you want to logically separate measures from fact and dimension tables for better organization.
• When you have more than 5 calculated columns in your data model.
• When you need to apply different relationships to measures.
• When you want to prevent users from accessing certain tables.

9. Which of the following DAX functions would you use to remove all filters from a specific table in a calculation?

• REMOVEFILTERS()
• FILTER()
• CALCULATETABLE()
• ALL()
• KEEPFILTERS()

10. In a DAX expression, which function would you use to calculate a total sales measure while ignoring any existing product category filters?

• CALCULATE([Total Sales], REMOVEFILTERS('Product'[Category]))
• CALCULATE([Total Sales], ALL('Product'[Category]))
• CALCULATE([Total Sales], FILTERS('Product'[Category]))
• SUMX(ALL('Product'[Category]), [Total Sales])
• REMOVEFILTERS([Total Sales])