Forum Discussion
Calculated Field in Pivot Table - Failed in calculation.
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.
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.
- It worked! Thanks Riny!