Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sometimes this is a drawback for the FirstSortedValue function: "If more than one value of expression share the same lowest sort-order, the function will return null."
Even where an expression has a single repeated value, it can be useful to have this value returned as the first entry, instead on Null.
Any tips on a neat and easy way of doing this ?
Thanks.
FirstSortedValue(Distinct Dimension, Expression)
You can use DISTINCT within FirstSortedValue() to show one of them, but to see both you might need to use Aggr() function together with FirstSortedValue.
FirstSortedValue(Distinct Dimension, Expression)
Two solutions
Thanks.
I wasn't aware that DISTINCT could be used here - I was relying on interactive help which doesn't show it as an option.