How should you complete the DAX expression?

HOTSPOT

You have a Power BI report.

You need to create a calculated table to return the 100 highest spending customers.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Box 1: TOPN

TOPN returns the top N rows of the specified table.

Box 2: SUMMARIZE

SUMMARIZE returns a summary table for the requested totals over a set of groups.

Box 3: DESC

Sort in descending order.

It is last in the TOPN command.

TOPN syntax:

TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])