Calculating Sum with a Group by

[Euro0681]

This may be a simple question but I'm needing to calculate the sum of sales but group by currency as a measure? 
to give an example (in SQL)

SELECT Sum(Sales), Currency
FROM Table

GROUP BY Currency

[tamerj1 · Accepted solution]

Hi @Euro0681 

please try

Measur =
SUMX ( VALUES ( 'Table'[Currency] ), CALCULATE ( SUM ( 'Table'[Sales] ) ) )