How to select a specific value from a table

[Niels_T]

Hello,

I would like to make a measure where I select a specific string out of a column.

Right now I have this dax measure:

Value = SELECTEDVALUE('Vendor List'[EU / Non-EU])

I select all values of that specific column. However I do not want that I only want to select all values that contain "EUR" for example.

[v-angzheng-msft · Accepted solution]

Hi, @Niels_T 

There are many ways to do that one.
Three of the simpler ways.
1. select Contains in the filter pane
2. Create a text filter visual
3. Create a measure similar to the one below and then filter the measure equal to 1 in the filter pane

Measure = 
IF(FIND("o",SELECTEDVALUE(financials[Product]),1,-1)<>-1,1,0)

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

Hi @Niels_T ,

I am not clear on your requirement.

May be something like below - (assuming there is a Currency column in your table)

extractValue =
CALCULATE (
    VALUES ( 'Vendor List'[EU / Non-EU] ),
    FILTER ( ALL ( 'Vendor List'[Currency] ), 'Vendor List'[Currency] = "EUR" ) )
)

Share more details:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Greg_Deckler]

@Niels_T You can use SEARCH or FIND. I'm not following the use case exactly.