Why total = 0 ?

Thanks for the reply from tamerj1 , please allow me to provide another insight:

Hi, sportive92003 

Regarding the issue you raised, my solution is as follows:
 

In response to your question, I offer two approaches:
 

1.The first is to use the HASONEFILTER () function as the basis for judgment, and then output the SUMX () function as the aggregate.
 

Here are the related links, I hope you will be helpful:

Dealing with Measure Totals - Microsoft Fabric Community
Measure Totals, The Final Word - Microsoft Fabric Community
 

2.The second is to convert the measures into groups of calculations and then modify the aggregation:
 

You can try the following code as a calculated column:

Then modify the way he aggregates: 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.