Exam 70-778 topic 1 question 103 discussion

1. Syntax in answer shows that this is a MEASURE formula and they ask us about TABLE formula, 2. You can't start table formula with CALCULATE, for this is CALCULATETABLE, 3. There is no table 'Customer' in the schema, 4. There is no column 'SalesProfit' i Sales table, There is no correct answer... Maybe they want us to write: CALCULATE(SUM(Sales[SalesAmount]);TOPN(10;Customers;CALCULATE(SUM(Sales[SalesAmount])))) This measure returns top 10 customers ordered by their sales amount

Anyone find it odd that both DAX expressions are operating on a column (Profit) that doesn't appear in the schema?

This is a good explanation: https://www.dutchdatadude.com/power-bi-pro-tip-confusion-about-topn-versus-rankx/

Correct. 1st fill must be a “Calculate”, becoz the 1st argument in the DAX is a measure, and then 2nd argument must be a filter or call “condition” that we need to get top10 as per “sum” of [SalesAmount]. TOPN(10, Customer, Sum[Sales[profit]) 1 -> Return a table containing 10 rows. 2 -> table displays CustermonName 3 -> “CustermonName “ order by “Sum[Sales[profit]”, sorting in descending by default. (which is like Query “group by” customer, and aggregator is “sum”) Ref: https://docs.microsoft.com/en-us/dax/topn-function-dax

Please check this link https://www.inflexionanalytics.com/power-bi-consulting-service-and-solutions/

Page 132 of text: "Power Pivot & PowerBI: Excel User Guide to DAX" - see page #132 for CALCULATE, TOPN for finding how top-heavy.... CALCLATE([TotalSales], TOPN (5, Products [Total Sales])

to create a new table use CALCULATETABLE then TOPN (i think the options given are incorrect for the first part of the question).

TOPN explanation https://docs.microsoft.com/en-us/dax/topn-function-dax

TOPN Returns the top N rows of the specified table.

I tested it, that measure...doesn't seem to work, it gives the same result as just putting the value into a table. Changing the "10" to a different value doesn't change anything at all, too. There is definitely something wrong with this question.

Filter requires a Table be passed, given there example it is not passing a table.

Wouldn't using calculate just calculates the value for the top 10 customers? shouldn't it be filter?