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] )+ ... ).
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.