Depot count by group

villa1980  , First Create a calculated column  

Capacity_Measure_Groups =
SWITCH (
TRUE(),
[Capacity_Used] > 1 , ">100%",
[Capacity_Used] >= 0.9 , "90-100%",
[Capacity_Used] >= 0.8 , "80-90%",
[Capacity_Used] >= 0.7 , "70-80%",
[Capacity_Used] >= 0.6 , "60-70%",
[Capacity_Used] >= 0.5 , "50-60%",
"<50%"
)

Then create a measure for count

Depot_Capacity_Count =
COUNTROWS (
VALUES ( HOO_AOM[Depot Name] )
)

In your table visual, use the Capacity_Measure_Groups column and the Depot_Capacity_Count measure. This way, the groups will be correctly displayed along with their counts, even when the depots are not shown in the table.