Aggregation not working with dim table

[Anonymous]

Hi all,

I am struggling to calculate an aggregated KPI displayed in a matrix.

Let's say I have a dim country table related to a fact sales table :

Country table:

Sales table :

My sales are calculated by month and country/city.
I want to display on a matrix the sales total  regardless of the month by country/city and month.

I used this measure :

Total_Sales_Per_Country = calculate(sum('Sales'[Sales]), ALLEXCEPT(Sales, Sales[FK]))

However, the result is :

But I want to obtain this :

Any idea why it is not working ?

Thank you in advance for your help !

Regards,

Alice

[Daniel29195 · Accepted solution]

@Anonymous 

use this modified version of the code : 

Total_Sales_Per_Country = calculate(sum('Sales'[Sales]), removefilters(sales[Month]) )

or

Total_Sales_Per_Country = calculate(sum('Sales'[Sales]), all(Sales) , values(sales[FK]))

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Anonymous]

Thank you for your answer, it worked !

Any idea why it doesn't work if I filter my sales by antoher column from the same table, like 

Total_Sales_Per_Country = calculate(sum('Sales'[Sales]),'Sales'[Category]="XXX", removefilters(sales[Month]) )

?