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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to get row count in table visual

Hi Team,

 

I need a measure that will give the count of rows from the table visual.

 

In the requirement, the user is selecting TOP N values from the TOP N filter and I want to show the same value in a measure that ' User has selected 5 values in the TOP N filter based on another measure.

 

I know we will not access the values user will enter in TOP N filter but how to get row count in visual?

An alternative solution in my requirement is the Measure should show DistinctCount Opptinumber values i.e 5 

 

Sample Data in table 

 

Oppty number    BU   Sales

1                          S    20

2                          A     30

3                           F      40

3                           P        50

3                           S         89

4                           A         30

5                            Au       40

 

 

Please help me with the implementation.

 

Regards,

Rajesh 

1 REPLY 1
lbendlin
Super User
Super User

@Anonymous 

COUNTROWS(VALUES(table[Oppty Number]))

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.