DAX formula which exclude the data only for the selected filter

[Anonymous]

Hello, 

I would like to create a measure which brings all data except for a selected filter option. 

Ex: 

* Filter Region (Latam, US, Europe)

* Sales

When I select the filter Region Latam, I would like to see only the sales from US and Europe. 

[Anonymous]

Since my filters involved other metrics, this was solved by creating another table from the one where the data is.

I linked the new table with the filter's one with the respective Region_ID needed for the analysis. 

Thanks to all!

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Developer/Compare-one-to-many-in-aggregate-dynamically-using-Slicer/m-p/564052#M17571
• https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846

[amitchandak]

Try

measure =
var _reg = except(Region[Region],allselected(Region[Region]) 
return
calculate(sum(sales[sales]),filter(all(Region),Region[Region] in  _reg))
//or
//calculate(sum(sales[sales]),filter(all(Region),Region[Region] =  _reg))

[amitchandak]

@Anonymous Does the above replies helps. if you need more help make me @

Appreciate your Kudos.

[Greg_Deckler]

See if Inverse Selector works for you. https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325