Dax SUM Issue - Column

Hi al1ceDav1n ,

Here are a few troubleshooting steps you can try:

• Check that the column is being recognized as a numeric data type. If it's not, you won't be able to sum it.
• Check that the column is not being filtered out by any filters in the query. If the column is being filtered out, it won't be included in the sum.
• Try using the SUMX function instead of SUM. SUMX allows you to sum a column that is the result of a calculation.   

Failure to deliver cash Settlement fails value =
SUMX ( TableName, [Failure to deliver cash Settlement fails value] )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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