Help with getting Average of Total Columns

[lennox25]

Hi - I hope someone can help?  I need to create a measure to calculate the average total of each column for A, B and C.

[selimovd · Accepted solution]

Hey @lennox25 ,

you can either create a dax measure to calculate the average:

myAverage = AVERAGE ( myTable[myColumn] )

Or if you use the column with the values directly you can change the summarization to average:

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[SivaMani]

@lennox25, Can you show the expected output?

[lennox25]

Hi  

The Average for A = 0.10

                           B= 1.43

                           C = 25.38