powerstate list by datacenter

[webmichael01]

Get-Datacenter | Select @{N = 'datcentername'; E = {$_.Name -replace '-','' }}, @{N = 'Cluster_Name'; E = {$datacenter.name}}, @{N = 'VM Count'; E = {( get-vm | where-object { $_.powerstate -eq "poweredOff"}).Count}}

how come this is adding the counts instead of breaking them out per count by Datacenter ?

Human error Im sure

datacenter1 312
datacenter2 312
datacenter3  312

I need it this formate for nodeExporter

[LucD · Accepted solution]

Because you do a Get-VM without a Location parameter, that will return all the VMs.
Use 

@{N = 'VM Count'; E = {( Get-VM -Location $_ | where-object { $_.powerstate -eq "poweredOff"}).Count}}

[webmichael01]

thank you sir I tried the location but I see was doing it wrong and leaving off $_

[webmichael01]

ignore sorry cant delete