Average DAX

[cottrera]

Hi 

I have a property table containing Street, Full Addesss and Scores. I would like to display a visual table showing just Street and an Average of Scores.   

For example Dax drive has two properties at this addess wih a combined score of 35 divided by 2 = a score of 17.5

Address Table

Street	Full Address	Scores
Dax Drive	26  Dax Drive	17
Dax Drive	7  Dax Drive	18
Power Close	10  Power Close	-1
Power Close	8  Power Close	-1
Power Close	9  Power Close	-1
Calculate Avenue	14  Calculate Avenue	9
Calculate Avenue	23  Calculate Avenue	8
Calculate Avenue	25  Calculate Avenue	18
Calculate Avenue	30  Calculate Avenue	8
Calculate Avenue	40  Calculate Avenue	8
Calculate Avenue	48  Calculate Avenue	10
Calculate Avenue	9  Calculate Avenue	8
Filter Close	1  Filter Close	5
Filter Close	11  Filter Close	5
Filter Close	15  Filter Close	4
Filter Close	3  Filter Close	4
Filter Close	7  Filter Close	4
Filter Close	9  Filter Close	6

Expected results

Street	Average of Scores
Calculate Avenue	9.9
Dax Drive	17.5
Filter Close	4.7
Power Close	-1.0

thank you RIchard

[mahoneypat · Accepted solution]

Ah.  In that case, you can use

Avg Score = AVERAGEX(DISTINCT(Table[Full Address]), [Scores])

Pat

[cottrera]

Thank you  I check a few and that seems to have done it

[mahoneypat]

You can just make a table visual with your Street column and a simple measure of

Avg Scores = AVERAGE(Table[Scores])  //replace Table with your actual table name

Pat

[cottrera]

Hi  Mahoney.pat

thank you for your quick response. I did try your idea but the column with the scores is already a measure. There for it does not work.

Richard