Level of detail calculation (Fixed / tableau software)

[Nouha]

Hello, 

I have a data set that looks like this 

and i need to calculate a column or measure that displays the sales per country , like this 

for those familiar with  Tableau that would be calculated using {Fixed [Country] : sum([Sales] }

Thank you very much 

Nouha 

[Greg_Deckler · Accepted solution]

Just create a measure like this:

Total Sales = SUM(Table[Sales])

Create a table visualization that has [Country] and [Total Sales] in it.

If you want this to be "durable" or "fixed" then you could create another measure like this:

Country Sales = CALCULATE([Total Sales],ALLEXCEPT(Table,[Country]))

 This second measure will exclude all other context filters except [Country].