Aggregate

[idontknowy]

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.afterbefore

[danextian]

Hi @idontknowy 

Did you use an implicit measure? Write a measure instead that explicitly specifies the aggregation: SUM ('Table'[column] )

[amitchandak · Accepted solution]

@idontknowy , You can change Default aggegation in Column tools. Better to create a measure

Measure = Sum(Table[Column])

[idontknowy]

thank you so much for the help @amitchandak