Forum Discussion

mp390988's avatar
mp390988
Post Partisan
10 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
    10 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.

v-echaithra's avatar
v-echaithra
Community Support
9 months ago

Hi mp390988 ,

Could you please confirm if the issue has been resolved or not. If a solution has been found helpful, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Best regards,
Chaithra E.