How to Calculate Total Number of Memory in Azure VM's

Dear Gurus

I need your kind help.

I have Azure account and I need to know how much memory I have total installed in all the Azure Cloud VM's. 

What I need below, which I took manually for 9 VM's in total there are 1000+ VMs'

For the Cores information, I use below command but there is no MEMORY information in it.

>Get-AzureRmVMUsage -Location WestUS

But how can I get the Memory details I do not know.?

Please help thanks.

Regards

Malik Adeel Imtiaz