Forum Discussion
Sum by different columns
I need get sum by ID and by PAYMENTS_ID
But measures return same result
Sum_EUR = SUM(Table[eur])
ID = SUMX (
VALUES(Table[id])
,[Sum_EUR]
)
PAYMENTS_ID =
SUMX (
VALUES(Table[payment_id])
,[Sum_EUR]
)
3 Replies
Digger , Not clear what you want. If they is not context used in [Sum_EUR], it will be same for both formula
i want sums by different columns, as column id have all sums, but other column has half of them because have a lot of blanks
Hello Digger,
not quite sure how your data looks, but if your ID is made of ID- numbers, and you do not want to sum those values without an ID, you can use this code:
Sum_ID =CALCULATE([Sum_EUR],Tabelle[ID] <> "")
