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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Goudi
Frequent Visitor

Add total rows

I have the following table with the filters 'Channel' , 'Crs_Book_No' and ' Departure Date'.

Goudi_0-1687859532903.png

I want to create another one in which I add up the number of rows of the previous table once the filters have been applied, what I have done is to create the table with the Channel column and another column with the channel count but it always gives me 1 as a result.

 

Goudi_1-1687859822796.png

 

Thanks!!!!

1 ACCEPTED SOLUTION
eliasayyy
Super User
Super User

hello did you try using countrows?

View solution in original post

1 REPLY 1
eliasayyy
Super User
Super User

hello did you try using countrows?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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