Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |