Hi,
I need to make a new COLUMN that shows the aggregated value of sales based on a city ( as a result I need to see the total number of sales fot each city for example for city Allen I need to see 290.21)
How can I do?
Thanks
Solved! Go to Solution.
@Giada90 ,
new column =
sumx(filter(Table, Table[City] = earlier(Table[City]) ), [Sales])
or
new measure=
sumx(filter(allselected(Table), Table[City] = max(Table[City]) ), [Sales])
@Giada90 ,
new column =
sumx(filter(Table, Table[City] = earlier(Table[City]) ), [Sales])
or
new measure=
sumx(filter(allselected(Table), Table[City] = max(Table[City]) ), [Sales])
User | Count |
---|---|
130 | |
81 | |
64 | |
57 | |
55 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |