MENU
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales. The sort order of the values of the fields is unknown. When two or more sales people have sold the same amount, the expression should return all of those sales people.
Which expression should the data architect use?
A)
B)
C)
D)
The requirement is to create a measure that identifies the salesperson with the highest sales. If multiple salespeople have the same highest sales amount, the measure should return all of those salespeople.
Explanation of Option A:
Rank(Sum(Sales), 1): The Rank() function is used to rank salespersons based on the sum of their sales. The rank 1 indicates the top position.
Aggr() Function: This function aggregates the data and returns the results grouped by the SalesPerson field.
IF() Condition: The IF condition checks if the salesperson's rank is 1 (highest sales).
Concat(DISTINCT ...): The Concat() function concatenates all the salespersons who have the highest sales, separated by spaces or another delimiter, ensuring that all top performers are returned.
Example:
If three salespersons have the highest sales, this expression will return all three names separated by a space.