Create a column to show the number of related rows from another table

[ShaheerAhmad]

Hello, as you can see here i have two tables: Class & Class Sections

both are related. i have a column in Class Sections Table that shows its parent Class.

I want to create a custom column in dataverse table that shows the numbers of sections of the class.

or in other words i want to create a column in Class Table to automatically count the number of related columns in Class Section Table.

I hope im clear enough. Im not sure how to achieve this. Need some help.

Thanks

[Mira_Ghaly · Accepted solution]

@ShaheerAhmad 

You need to create a roll-up column for this purpose.

Please find below link to guide on how to create roll-up columns

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/calculated-rollup-attributes#rol...