Filtering with Dax

[vaishali12]

Hi, 

I have one table with countries and region.  I would like to select a country and have a table that returns all the countries in the same region as the selected country.  I currently only have a slicer to be able to select a country. 

Sample country Table: 

Region	Country
Europe	Germany
Europe	France
Europe	Netherlands
Europe	Italy
Asia	India
Asia	China
Latin America	Venezuela
Latin America	Uruguay

Expected output: 

Selected country - Germany

Region	Country
Europe	Germany
Europe	France
Europe	Netherlands
Europe	Italy

[v-juanli-msft · Accepted solution]

Hi @vaishali12 

In SSAS Live mode, it is impossible to create a measure to achieve your goal.

I make a test as below.

Create two slicers,

Edit their interactions as below:

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @vaishali12 

Create another table

Table = SUMMARIZE(Table1,Table1[Country],Table1[Region])

In Table1,

Create measures

Measure = SELECTEDVALUE('Table'[Region])

Measure 2 = IF(MAX(Table1[Region])=[Measure],1,0)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vaishali12]

Hi @v-juanli-msft , 

Thank you for the response. I attempted your solution, but it does not work in my case. 

I am using a SSAS connection and do not have the option to create new calculated tables. This is what my Modelling tab looks like. 

Do you know if there is an option to do the same with just using measures? Thanks!