Forum Discussion

idontknowy's avatar
idontknowy
New Member
1 year ago
Solved

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

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    1 year ago

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

     

    Measure = Sum(Table[Column])

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    1 year ago

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

     

    Measure = Sum(Table[Column])

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi idontknowy 

     

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