Forum Discussion
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...
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 forSales[Transaction Size]could result in an error.
Hi mp390988 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.