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've searched and found nothing, so apologies that my first post is an issue/question. The built-in Top N filter feature works fine for non-calculated columns/measures, but whenever I try to do a top N filter for a measure, I get results of practically the whole list vs. just the top 5 or 10 I want in the visual. I know I could be using Rank X and other formulas, but honestly, this is a poor solution, something that Tableau solved a while ago.
In the example below, I only want the top 5 stores for Sales $'s/Transaction. The Sales/Trans is a measure of the formula Sum(Sales $'s)/Sum(Transactions).
Here's what happens, clearly it's more than the top 5:
@Anonymous
I tested with a similar sample as below but cannot repro the same issue. Could you please provide your PBIX file or some sample data to me? I can take a look to see if there are some wrong configurations.
Best Regards,
Herbert
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |