Forum Discussion
Get the average value per row with multiple columns
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]+T...
Anonymous , 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] )+ ... ).
ERD
Community Champion
Community ChampionAnonymous , 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] )+ ... ).
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!