Forum Discussion
Calculated Field in Pivot Table Not Summing Correctly
With calculated field in total PivotTable uses the same formula as for the rows, not sum them. Thus if your IF() applied to totals returns 1, in grand total for FTE will be 1.
For such calculations it's better to add data to data model creating PivotTable and use DAX measures for aggregations.
With calculated field in total PivotTable uses the same formula as for the rows, not sum them. Thus if your IF() applied to totals returns 1, in grand total for FTE will be 1.
For such calculations it's better to add data to data model creating PivotTable and use DAX measures for aggregations.
SergeiBaklan Would SUMX be the right DAX formula?
Perhaps, it's hard to say without knowing the model. Here When to Use SUM() vs SUMX() - Excelerator BI is the great post which explains and demonstrates difference between SUM and SUMX
