Get the average value per row with multiple columns

[Anders_Dahl]

How to get the Average value with rows

As you can see in the table below. I want get the average value for each row.

I have tried so many things.

AVERAGEX(Table, Table[City 1]+Table[City 2]+Table[City 3])

But this give me the SUM.

I also would like to get median value as well.

Color	City 1	City 2	City 3	Avreage
Yellow	2	7	6	5
Blue	10	10	10	10
Green	12	89	57	52,66667

I hope the comunity can help me 🙂

[ERD · Accepted solution]

@Anders_Dahl , do you have these cities as separate columns? I would unpivot them first, otherwise you'll have to define each value with SELECTEDVALUE, for example AVERAGEX(Table, SELECTEDVALUE ( Table[City 1] )+ ... ).

[Anders_Dahl]

I did use the unpivot and then i used Averagex and filter togheter and it worked perfect.
Whit this i understand how work with the tables.
So thanx!

[Anders_Dahl]

Hi @Nate123 

Yes i can, but i want this to be dynamic.

I want to know why this is acting like it does. I can use other DAX to get the average.

[Nate123]

Could you sum them and divide by 3?