How to filter/narrow down table rows using DAX measure

[mrchonginhk]

I have a DAX measure returning a text "Asia"
I have a table containing only 2 columns like this:

Region | Sales
===========
Europe | 100
Asia | 300
etc
I wish to using this DAX value "Asia" so that the new table will only shows the Asia row.
How can I do this ?
Thanks

 

[JustynaMK]

Hi,

I think what you want to achieve can be done by creating a "New Table":
Asia = FILTER('Table', 'Table'[Region] = "Asia")

Here's the result: