Forum Discussion
Solved
Measure calculation
Hello, I have a column with the name of a company the number of transaction and the percentage : I would like to calculate the sum of the transaction for a company + the same number * t...
measure =
var total = sum(transactions)
var abandoned = sumx(transactions * abandoned%)
return
total + abandoned
.....something like that? (you'll still have to add the filter conditions etc)
Typically when you see totals not adding up correctly like this and they involve multiplying columns and percentages and row level calculations etc, you need to experiment with SUMMARIZE and/or SUMX