Forum Discussion
idontknowy
1 year agoNew Member
Aggregate
Hi, I have encountered a scenario wherein initial aggregate is SUM but after creating a relationship with another table the aggregate changed to COUNT. what could be possible reason for this. TIA. ...
- 1 year ago
idontknowy , You can change Default aggegation in Column tools. Better to create a measure
Measure = Sum(Table[Column])
danextian
1 year agoSuper User
Hi idontknowy
Did you use an implicit measure? Write a measure instead that explicitly specifies the aggregation: SUM ('Table'[column] )