Your company has 100 product subcategories and more than 10,000 products. You have a PivotChart that uses Manufacturer as the axis and the sum of SalesAmount as the values. You need to ensure that only the top 10 manufacturers appear in the chart. What should you do? A. Configure the Value Filters B. Summarize the […]

You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.) Exhibit: Your company has 100 product subcategories and […]

There is a relationship between Products and ProductCategory. You need to create a hierarchy in Products that contains ProductCategoryName and ProductName. Solution: You create a measure that uses the ISCROSSFILTERED DAX function Does this meet the goal? A. Yes B. No

There is a relationship between Products and ProductCategory. You need to create a hierarchy in Products that contains ProductCategoryName and ProductName. Solution: You create a calculated column that uses the RELATED DAX function Does this meet the goal? A. Yes B. No References: https://www.mssqltips.com/sqlservertip/2900/creating-hierarchies-in-powerpivot-for-excel/ https://msdn.microsoft.com/en-us/library/ee634202.aspx

You have a Power Pivot model that contains the following tables. There is a relationship between Products and ProductCategory. You need to create a hierarchy in Products that contains ProductCategoryName and ProductName. Solution: You create a measure that uses the USERELATIONSHIP DAX function. Does this meet the goal? A. Yes B. No

Solution: You add a PivotTable. You drag ProductCategory, ProductSubCategory, and ProductName to the Rows field. You drag Price to the Values field. Does this meet the goal? A. Yes B. No

Solution: You create a hierarchy named Products that contains ProductCategory, ProductSubCategory, and ProductName. You add a PivotTable. You drag Products to the Rows field. You drag Price to the Values field. Does this meet the goal? A. Yes B. No

You have an Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the following table. You need to create a PivotTable in PowerPivot as shown in the exhibit. (Click the Exhibit button.) Solution: You create a measure named products the uses the DataTable DAX function. You […]