Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the TopN filter and when I do I do it returns more than the N i requested. I used top 10 agents by conversion but it returned almost 30 agents. Does conversioni= infinity or NaN have anything to with it? If I take those out I still get more than ten agetns listed. All help is apprecitated.
In DAX, when using TOPN() function, it returns top N rows based on the order_by_expression. However if the order_by_expression has same values, those rows will be retrieved. That's the reason why you get more than 10 agents.
Regards,
It's giving you everyone that's tied for the same spot. I think that's what @v-sihou-msft is saying too but I'm not sure. Anyway topn returns the matches for the top n scores, not the first n matches it finds. So imagine you want the top 10 people, but 3 people are tied for number 1, 7 are tied for number 2, and there's only 1 each for 3rd place through 10th place. TOPN will give you 18 people, not 10. If you only want 10, you need to come up with a way to calculate a tie-breaker that will force each person to have a unique score.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |