Forum Discussion
How to select a specific value from a table
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:
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 paneMeasure = 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.
3 Replies
Niels_T You can use SEARCH or FIND. I'm not following the use case exactly.
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
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 paneMeasure = 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.
