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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Total rows column

Hi, I would like to add a column with the sum of total rows.

However, it shows fail if I used "Allselected"

alexng_0-1663899279589.png

May I ask is there any other measure to achieve the same?

IDTotal rows
14
24
34
44

 

Thanks!

2 REPLIES 2
Arul
Super User
Super User

@Anonymous ,

try this or modify based on your requirement,

row count = 
CALCULATE (
    COUNTROWS ( VALUES ( 'tablename'[ID] ) ),
    ALLSELECTED ()
)

Thanks,





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Anonymous
Not applicable

@Arul still the same error, I think its because of the direct query modeling

So trying to see if any simple DAX can achieve the same.

Thanks

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.

Top Solution Authors