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
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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

Top Solution Authors