Measure error to avoid blank pie chart "The function SUM cannot with values of type String"

I am creating a dashboard with various different pie charts that will be refreshed periodically throughout the year. I have one pie chart that currently has no data available and is therefore appeari...