Forum Discussion

UK_User123456's avatar
UK_User123456
Resolver I
7 years ago
Solved

Average Calculation

Hi All,   I have the below data, im just simply trying to do an average calulcation for each of the ID's that I have, normally I would have just put the "Amount" into the values field and used the ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    cosminc yeah. You can use the little down arrow there to change it to any other summarization type, such as average. Or of course write an explicit measure that does the same thing. Such as...

     

    Avg Amount = AVERAGE(TableName[Amount])

     

cosminc's avatar
cosminc
Post Partisan
7 years ago

Hi

the column Amount is number type and Modelling - Default summarization is Sum?

 

Hope it helps,

Cosmin

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

cosminc yeah. You can use the little down arrow there to change it to any other summarization type, such as average. Or of course write an explicit measure that does the same thing. Such as...

 

Avg Amount = AVERAGE(TableName[Amount])

 

  • UK_User123456's avatar
    UK_User123456
    Resolver I
    7 years ago

    Hi All,

     

    Thanks for the response, it just clicked to me after reading your responses that my amount for some reason when imported into power bi it changed the format to text when it should have been whole number which is the reason I couldnt summarise it.

     

    Thanks