DAX RANKX And Drill Through MCQS

Q. What does RANKX() do in DAX?

A

Formats text

B

Ranks rows of a table based on an expression

C

Deletes duplicate rows

D

Creates a relationshi

Solution:

RANKX() assigns a rank to each row of a table based on the value of a given expression.

Q. What is drillthrough in Power BI?

A

A way to right-click a data point and jump to a pre-filtered detail page

B

A type of chart

C

A data connector

D

A way to delete a report page

Solution:

Drillthrough lets a viewer jump from a data point to a dedicated, pre-filtered detail page.

Q. What does Power BI automatically add to a drillthrough destination page?

A

A back button

B

A new table

C

A slicer

D

A bookmark

Solution:

Power BI automatically adds a back button to a drillthrough page so viewers can return to where they started.

Q. How can Top N filtering be applied in Power BI?

A

Only through a visual-level filter

B

Only through DAX with TOPN()

C

Through either a visual-level Top N filter or DAX using TOPN()

D

Only by manually deleting rows

Solution:

Top N filtering can be applied either as a visual-level filter type or in DAX using the TOPN() function.

Q. What does RANKX(ALL(Products), [Total Sales]) rank against?

A

Only the currently filtered subset of Products

B

The full, unfiltered list of Products regardless of any applied filter

C

A single product

D

The Sales table directly

Solution:

Wrapping the table argument in ALL() removes existing filters, so the ranking is calculated against the complete list.

Q. What is Drillthrough Filters' relationship to the other filter types (visual-level, page-level, report-level)?

A

It's a special filter type used specifically on a dedicated drillthrough page, triggered by right-clicking a data point

B

It's identical to a page-level filter

C

It's the same as a report-level filter

D

It only applies to slicers

Solution:

Drillthrough filters are their own category, distinct from visual-, page-, and report-level filters, and only activate via the drillthrough interaction.

Q. What does RANKX() do in DAX?

Solution:

Q. What is drillthrough in Power BI?

Solution:

Q. What does Power BI automatically add to a drillthrough destination page?

Solution:

Q. How can Top N filtering be applied in Power BI?

Solution:

Q. What does RANKX(ALL(Products), [Total Sales]) rank against?

Solution:

Q. What is Drillthrough Filters' relationship to the other filter types (visual-level, page-level, report-level)?

Solution:

Related Questions

Q. DAX Variables MCQS

Q. DAX CALCULATE Function MCQS

Q. DAX Text Functions MCQS

Get Question Bank