Sum of sales with the condition

[krzysztof]

I'd like to make a sales sum on all the stores except number 100

Total Sales = Calculate(Sum(Revenue);All(Localization[StoreID]) <-- How to add to this a condition that excludes shop 100

[amitchandak · Accepted solution]

@krzysztof 

Try

Total Sales = Calculate(Sum(Revenue);Localization[StoreID]<>100)

Total Sales = Calculate(Sum(Revenue);filter(All(Localization),Localization[StoreID]<>100))

if you need more help make me @

Appreciate your Kudos.