Measures to extract all values after a specific text string

[JohnGray]

Hello,

I have a data feed coming in from a source that lumps all Customer IDs together into one column, even though there are different "categories" of customers. The customer IDs are in a single column much like this:

I would like to be able to use a measure to extract only the customer with the DAX ID, with the result of the measure showing the full ID (i.e., DAX123456789, etc). What would be the best way to go about doing this? 

Please note: I am using a live Power BI data dataset connectivity and as such must use a measure; I cannot create clumns or access Power Query. 

[v-rzhou-msft]

Hi @JohnGray ,

I suggest you to create a measure as below.

Filter = 
IF(CONTAINSSTRING(MAX('Table'[Subject ID]),"DAX"),1,0)

Add this measure into visual level filter and set it to show items when value = 1.

Best Regards,
Rico Zhou

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

[JohnGray]

Hello Rico,

Thank you for your suggestion. This does indeed work if I put the data into a Table View, but if I try to put it into say, a Pie Chart, it doesn't show distinct values and only shows a single "1" for the whole pie chart. Do you know if theres a way to count all the 1 values as distinct values so they can be better visualized? 

[vicky_]

You'll want to look at the CONTAINSSTRING() function as a filter for that column when creating measures. https://learn.microsoft.com/en-us/dax/containsstring-function-dax