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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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).
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 42 | |
| 30 | |
| 26 | |
| 23 |
| User | Count |
|---|---|
| 132 | |
| 113 | |
| 57 | |
| 39 | |
| 35 |