Dax problem

[Anonymous]

I have to create dax for a country with sales but I want that especially this field (dax) won't affect by any slicer, it should be fixed. 

what dax should I write? 

and also if I  want only Europe Margin and that won't be changed by any slicer. for this what dax should I write?

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

calculate(sum(Table[Value]), filter(all(Table[Country]), Table[Country] in {"Germany", "Holland"}))

or

calculate(sum(Table[Value]), filter(all(Table), Table[Country] in {"Germany", "Holland"}))