Exam PL-300 topic 2 question 92 discussion

Actual exam question from Microsoft's PL-300

Question #: 92
Topic #: 2

HOTSPOT
-

You have a Power BI semantic model that contains a table named Item. The Item table contains a column named Quantity.

You need to create a DAX query that meets the following requirements:

• The rank of items must be calculated according to the values in Quantity.
• Ranking must NOT be skipped if two or more items have the same value in Quantity.
• If an item is unfiltered, the total of Quantity must display a blank value.

How should you complete the DAX formula? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by nammm112 at Sept. 5, 2024, 10:24 a.m.

Comments

Submit Cancel

[Removed]

Highly Voted 4 months, 3 weeks ago

HASONEVALUE ('Item'[Item]) check if 'item' is filtered to a single value. if not, it returns blank by default. Rank method : DENSE ensure that ranks are not skipped when there are ties.

upvoted 7 times

...

0f4908c

Most Recent 1 week, 6 days ago

Selected Value Example = SELECTEDVALUE(Products[ProductName], BLANK()) ? HASONEVALUE need IF

upvoted 1 times

...

jaume

3 months ago

RANKX(<table>, <expression>[, <value>[, <order>[, <ties>]]]) <expression> to evaluate for ranking (within the <table>) <value> is optional; if omitted, current row's value in <expression> is used <order> (optional) to set sort order (ASC, DESC) <ties> is also optional and determines how ties are handled SKIP: skips rank for ties (e.g ranks 1,2,2,4) DENSE does not skip ranks for ties (e.g. ranks 1,2,2,3)

upvoted 1 times

...

hatem.ayed

5 months, 1 week ago

HASONEVALUE garantiza que la fórmula se ejecute únicamente cuando haya un solo valor de Item seleccionado. Esto evita que se devuelva un valor de clasificación cuando no se ha seleccionado ningún elemento, cumpliendo con el requisito de mostrar un valor en blanco si no se ha filtrado ningún elemento. DENSE se asegura de que, si dos o más elementos tienen la misma cantidad, no se omitan números en la clasificación, lo cual era otro de los requisitos.

upvoted 4 times

...

nelrosell

5 months, 2 weeks ago

Correct Answer: HASONEVALUE, DENSE

upvoted 4 times

...

nammm112

5 months, 2 weeks ago

Wrong. It should be HASONEVALUE and DENSE

upvoted 3 times

...

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam