Forum Discussion
Calculated Field in Pivot Table - Failed in calculation.
I tried to use the "Fields, Items, & Sets' in PivotTable and sum up the number from 1st column to 4th column but turns out the result showed is zero in the 5th column. Does anyone know how could this happen and how to fix it?
Stanly_LIEW The calculated field is summing contact numbers, which presumably are texts. Hence, a sum of zero. Your intention is to sum the count of contacts. Then you need to add the source data to the Data Model and create three DAX measures. Two that count the number of entries in each of the contact columns and one that sums these two counts.
6 Replies
- You need to show the formula bar in your screenshot and share what formula you were using.
Here is what I did on the Pivot Table. I was just using the simple calculation but it has nothing turned out.
Stanly_LIEW The calculated field is summing contact numbers, which presumably are texts. Hence, a sum of zero. Your intention is to sum the count of contacts. Then you need to add the source data to the Data Model and create three DAX measures. Two that count the number of entries in each of the contact columns and one that sums these two counts.
