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.
Hello everyone,
I use TOPN filter for "Com" on a matrix visual.
When I use Top10 like below:
Business | Customers | Com |
ABC | aa | 31.48 |
bb | 30.45 | |
cc | 30.43 | |
dd | 30.38 | |
ee | 30.30 | |
ff | 20.10 | |
gg | 19.50 | |
hh | 19.20 | |
ii | 19.18 | |
jj | 19.14 |
When I use Top15 like below:
Business | Customers | Com |
ABC | aa | 31.48 |
bb | 30.45 | |
cc | 30.43 | |
11 | 30.43 | |
dd | 30.38 | |
ee | 30.30 | |
ff | 20.10 | |
22 | 20.02 | |
gg | 19.50 | |
33 | 19.40 | |
hh | 19.20 | |
ii | 19.18 | |
44 | 19.15 | |
jj | 19.14 | |
55 | 18.32 |
I was expecting Top1 - 10 of Top15 result would be the same.
How should I correct it?
Thanks,
Vladi
Hi @PbiCeo ,
I can't see any points through the screenshot, please show more information. Something like sample data and the formula you are using would be helpful.
Best Regards,
Jay
Thank you for your reply.
Alternatively I tried to use DAX measure, Rankx with condditions using filter to then correctly filter by Topn filter, but it retuns always only 1.
@PbiCeo has any other filter changed. I did not saw customers 11 and 22 in the first list. Can you check that.
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello @amitchandak ,
Thank you for your reply.
Alternatively I tried to use DAX measure, Rankx with condditions using filter to then correctly filter by Topn filter, but it retuns always only 1.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |