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.
Members,
How does the Top N work when the values are same for different records?
From what I have tried, it does not show a record with Top N visual filter. What is the reason? How can this be corrected?
I have attached a Power BI sample file.
Thank You!
Solved! Go to Solution.
Thank You @mussaenda! That worked.
So, what is the difference in the DAX is used and your DAX. The results are the same but just the filter is not working in my scenario.
Hello @BBIUser ,
I think it would show both the records for which the values are same.
In your example, both the records with same value stand at 4th position. So it would show both the values.
@rajulshah You are right but what happens is when I apply Top N the 3rd record will be hidden / removed in the table visual (by applying Top 3).
Try clearig the Top N visual level filter in the Power BI file and you will see the difference.
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |