Forum Discussion
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.