Exam 70-779 topic 1 question 36 discussion

1.measure 2. kpi 3.pivot table

Shouldn't the Create a pivot table be the last action after the measure and KPI are created?

1. PV table 2. Measure 3. KPI There are 3 places to create measure and 2 places to create KPI. Place 1 for explicit measure and KPI, under Tab “power pivot”; Place 2 for explicit measure and KPI, in the data model, under specific table, any black area. Once you create the measure, and then right click this measure you will see the KPI option; Place 3 for implicit measure is we just simply put the auto Fx (sum, avg, count…etc) into pivot table field lists’ Value area. In summary, no aggregate, no measure, only under 1 situation we could put the PV table at last step, that is we already imported data into data model, and we already created a explicit measure under that particular tab, and create KPI accordingly.

first you need create the table then measure then kpi 1.In the Excel window, click Power Pivot> Calculations> Measures> New Measure. 2.In the Measure dialog box, for Table name, click the down arrow, and then select the table you want the measure to be in. https://support.microsoft.com/en-us/office/create-a-measure-in-power-pivot-d3cc1495-b4e5-48e7-ba98-163022a71198

Tried and tested. Pay attention to the wording: add a table to a data model 1. Create a Pivot Table 2. Create a Measure 3. Create a KPI you can't create measures and KPIs in the data model.

pivot table is the last step

Don't we need the PivotTable before we generate the measure? in which case: Table, measure, then KPI https://support.microsoft.com/en-us/office/key-performance-indicators-kpis-in-power-pivot-e653edef-8a21-40e4-9ece-83a6c8c306aa

Correct order Pivot Table / MEASURE / KPI Tested

Sorry I go by the create a pivot table , kindly disregard my initial submission . I was mislead by the statement create "visualization" didn't take note of the "like the one below"

Rather I think it should be measure , KPI and create chart. Since the question says you add the table to a model . You can't possibly add a table to model without first creating a pivot table. Or excel creates the pivot table automatically as you add a table to a model