Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
harryhhj
New Member

CountRows() function not responding to filter context

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.

 

 table.PNGresults.PNG

2 REPLIES 2
amitchandak
Super User
Super User

@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).

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.