Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowIf 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
93 | |
67 | |
65 | |
43 | |
40 |