Forum Discussion

mp390988's avatar
mp390988
Post Partisan
9 months ago
Solved

Distinct inside a calculate function

Hi,   I was going through a question on the PL300 exam and noticed the solution has explicitly written a distinct as the first argument of a calculate function as marked in the snippet below. I did...
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 months ago

    Hi mp390988 

    You've hit the nail on the head 🙂 A single-column table with at most one row is treated as a scalar value if the context requires. In the case of zero rows, the value returned is BLANK.

    See here.

     

    In this case, the configuration of the 'Transaction Size' table ensures that the result will have at most one row.

    If 'Transaction Size' were misconfigured and had rows with overlapping [Min,Max] ranges, this expression for Sales[Transaction Size] could result in an error.

OwenAuger's avatar
OwenAuger
Super User
9 months ago

Hi mp390988 

You've hit the nail on the head 🙂 A single-column table with at most one row is treated as a scalar value if the context requires. In the case of zero rows, the value returned is BLANK.

See here.

 

In this case, the configuration of the 'Transaction Size' table ensures that the result will have at most one row.

If 'Transaction Size' were misconfigured and had rows with overlapping [Min,Max] ranges, this expression for Sales[Transaction Size] could result in an error.