PL-300 Exam - Question 141

Question

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.

Examice · Accepted Answer

.

[Removed] · Answer

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.

nelrosell · Answer

Correct Answer: HASONEVALUE, DENSE

hatem.ayed · Answer

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.

nammm112 · Answer

Wrong. It should be HASONEVALUE and DENSE

jaume · Answer

RANKX(, [, [, [, ]]])
             to evaluate for ranking (within the )
             is optional; if omitted, current row's value in  is used
             (optional) to set sort order (ASC, DESC)
             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)

0f4908c · Answer

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

PL-300 Exam - Question 141

Discussion