Dax Total incorrectly 0 (Currently using If with Text)

Good Morning,    I currently have the below formula that brings through the correct figure when filtered by location (see below), however the total is 0 despite values being present, This is likely...