Sum by different columns

[Digger]

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]

)

[hashtag_pete]

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] <> ""

)

[amitchandak]

@Digger , Not clear what you want. If they is not context used in [Sum_EUR], it will be same for both formula 

[Digger]

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