Calculating Sum with a Group by

Euro0681 — Tue, 22 Nov 2022 16:36:34 GMT

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

Re: Calculating Sum with a Group by

tamerj1 — Tue, 22 Nov 2022 16:50:35 GMT

Hi Euro0681

please try

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

topic Calculating Sum with a Group by in DAX Commands and Tips

Calculating Sum with a Group by

Re: Calculating Sum with a Group by