To use avg_page_space_used_in_percent you will also have to change your query to run in DETAILED mode, like this:

...

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, 'DETAILED') AS ps

...