Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Counting values based on a list

Hi

 

I want to load a list of text strings in PowerBI and use that list so that I count the entries in another field that either start or contain any of these text strings.

 

I may need to add or remove entries from that list.

 

What is the best strategy to do that?

 

Thank you

Need Help

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    It seems easier to do it with DAX.

    Please show us a sample data.

     

    Best regards,
    Lionel Chen

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-lionel-msft  thanks

       

      Sample text strings that need to be filtered out if they appear in the beginning of values:

      ABC DFG

      EEE REE

       

      Sample text strings that need to be filtered out if they appear in anywhere in the values:

      WER TYE

      EGR THE

       

      I plan to do it with DAX but I want to maintain the above lists in separate tables. Is that possible? What would be the DAX formulas to count such matches?