Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric certified for FREE! Don't miss your chance! Learn more
Found the issue in a complicated measure and then tested with only CountRows() along with a Calculate(). When I change slicer selections CountRows() always showed the result of the whole table but Calculate() gave the filtered table.
TopN() has same issue.
@harryhhj , hope you are using
CountRows(table)
refer for TOPN
TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
Thanks Amitchandak, what I found in my testing is calculate(distinctcount(topN(allexcept(table, column1))) didn't respond to slicers on column1 correctly. I didn't test more but feel that many functions don't work correctly with filter context (very likely a bug).
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 68 | |
| 59 | |
| 47 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 106 | |
| 102 | |
| 38 | |
| 27 | |
| 27 |