Using DAX VAR to calculate total

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

Hi  Anonymous ,

Does a blank total mean that the Total row placed in the form visual does not show the correct value?

Measure follows the context of the "Total" row and is calculated in that context. Therefore, using a measure in a column of a table visualization may have unexpected values in the "Total" column.

You can use the following measure, using the IF()+HASONEVALUE() function, to determine if it is Total, and if it is, you can calculate it according to your own needs, such as Average, Sum, etc.

You can try using the following measure.

Measure_ totals =
var _table=SUMMARIZE('Table','Table'[Place the first column of the matrix],"Value",[ Y3_test])
return
IF(
    HASONEVALUE('Table'[Place the first column of the matrix]),[ Y3_test],SUMX(_table,[Value]))

Best Regards,

Liu Yang

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