Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Hoping you could possibly help, I'm having an issue with the below DAX as there are duplicates in the dataset, so TOPN wont run and the visual fails as "A table of multiple values was supplied where a single value was expected".
I want to receive the name of the MAX salesperson but in one scenario 2 salespersons have sold 9 then the visual fails.
Yet, any other filter applied where there are unique sales values the visual works fine and is able to calculate the MAX salesperson.
Add a small random number to the sum of sales for each rep to break the ties.
User | Count |
---|---|
94 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |