Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
If Trips is sum or a number column
Sumx(Table, Table[trips]*Table[Distance round])
Or if you want multiplication after agg then do at a level
sumx(summarize(Table,Table[Kod Dp..],"_1",Sum(Table[Distance round]),"_2",[Trips]),[_1]*[_2])
Taking a group level for correct multiplication
If Trips is sum or a number column
Sumx(Table, Table[trips]*Table[Distance round])
Or if you want multiplication after agg then do at a level
sumx(summarize(Table,Table[Kod Dp..],"_1",Sum(Table[Distance round]),"_2",[Trips]),[_1]*[_2])
Taking a group level for correct multiplication
Try SUMX()
Can you provide the sample table and expected output.
Also the logic of Distance.
User | Count |
---|---|
113 | |
71 | |
57 | |
44 | |
39 |
User | Count |
---|---|
176 | |
125 | |
61 | |
60 | |
58 |