How to find number of rows in each partition

How to get partition Information including no of rows in each partition.

SELECT

     SCHEMA_NAME(t.schema_id) AS [Schema]

    ,OBJECT_NAME(i.object_id) AS [ObjectName]

    ,p.partition_number AS [Partition_Number]

    ,fg.name AS [Name_Of_FileGroup]

    ,rows AS 'Number_Of_Rows'

    ,au.total_pages AS 'Number_Of_Pages'

    ,CASE boundary_value_on_right

        WHEN 1 THEN '<'

        ELSE '<='

     END AS 'Compare'

    ,value AS 'Compare_Value'

    ,p.data_compression_desc AS 'Data'

    ,p.partition_id AS [Partition ID]

FROM sys.partitions p

    JOIN sys.indexes i ON p.object_id = i.object_id AND p.index_id = i.index_id

    JOIN sys.partition_schemes ps ON ps.data_space_id = i.data_space_id

    JOIN sys.partition_functions f ON f.function_id = ps.function_id

    LEFT JOIN sys.partition_range_values rv ON f.function_id = rv.function_id AND p.partition_number = rv.boundary_id

    JOIN sys.destination_data_spaces dds ON dds.partition_scheme_id = ps.data_space_id AND dds.destination_id = p.partition_number

    JOIN sys.filegroups fg ON dds.data_space_id = fg.data_space_id

    JOIN (SELECT container_id, sum(total_pages) as total_pages

            FROM sys.allocation_units

            GROUP BY container_id) AS au ON au.container_id = p.partition_id

    JOIN sys.tables t ON p.object_id = t.object_id

WHERE i.index_id < 2

ORDER BY 5 Desc

GO