Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Searching Substring in VALUES

Hi   I have a Measure that finds all the items in my main table where a certal car model is selected. Here's the DAX   Leads Qualified Consumer (1) Model = IF( SELECTEDVALUE...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi

     

    thanks, I solved using SEARCH

     

    sumX('Purchase Order - Models';countrows(filter(Leads;Leads[Qualification]="Qualified" && Leads[Type - New 1]=TRUE() && searcH('Purchase Order - Models'[Model];Leads[Model Name] ;1;-1)>0 )));

    So this cycle through all the "models" and return true if it finds all values where the text is found

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous,

Could you please share some sample file to have a test and post your desired result if possible?

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

thanks, I solved using SEARCH

 

sumX('Purchase Order - Models';countrows(filter(Leads;Leads[Qualification]="Qualified" && Leads[Type - New 1]=TRUE() && searcH('Purchase Order - Models'[Model];Leads[Model Name] ;1;-1)>0 )));

So this cycle through all the "models" and return true if it finds all values where the text is found