Help with aggregated target performance measures, blank values and incorrect results

Hi   JadeM 

Yes, the lack of matching values is indeed the cause of blanks. To solve this problem, there are two ways.

The first is to add a new column to the Fact table to group categories without matching values into matching value categories, such as classifying small electric car, large electric car as Cars. In this way, the values in the new column and the [Short target] values in the Overview table can exactly match, and then the relationship is based on the new column and the [Short target] column. For example, 

Another way is to modify the measures. Remove the filtering of existing relationship from the measures, and then filter the matching values by expressions. For example, 

Recycling = 
VAR Recycling = CALCULATE(SUM('Fact'[Actual]), REMOVEFILTERS('Fact'[Value]), 'Fact'[Value] = "Total recycling" )
VAR TotalWaste = CALCULATE(SUM('Fact'[Actual]), REMOVEFILTERS('Fact'[Value]), 'Fact'[Value] IN {"Total recycling", "Total landfill", "Total incinerated"}) 
RETURN 
IF(TotalWaste > 0, Recycling / TotalWaste, BLANK())

Modify [Recycling], [Landfill] and [eCar] measures similarly. 

Hope this would be helpful. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!