+ Reply to Thread
Results 1 to 3 of 3

Power BI - Wildcard - count partial match

  1. #1
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    Power BI - Wildcard - count partial match

    Hi,

    I'm new to Power BI. I've been searching on Google but somehow can't find any answer.

    In Excel we have Wildcard. What options do we have in Power BI?

    I have a column with text strings. I want to count how many times the words "Combi Port" occure.

    This is my work so far.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Power BI - Wildcard - count partial match

    In Power BI you might try something like below (*untested*):

    Measure =CALCULATE(COUNTROWS(Salg), SEARCH("Combi Port", Salg[Product Name],, 0)>0)

  3. #3
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    Re: Power BI - Wildcard - count partial match

    Really nice. This is working.
    Is there any trick to add more criteria. This is not working:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count Unique Values with Partial Match one column exact match another column
    By carsto in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-30-2019, 09:56 AM
  2. [SOLVED] Count partial match based on single records
    By sted999 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-02-2018, 08:37 AM
  3. Wildcard in Excel is selecting full string instead of partial text.
    By Jriggerz in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2017, 06:11 AM
  4. [SOLVED] Lookup partial values and if match return partial value from another cell
    By Renejorgensen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-01-2017, 07:53 AM
  5. count ifs with partial match
    By Glüscht in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2016, 04:19 AM
  6. Table Array with Wildcard involving partial URL match
    By tworoads in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-29-2014, 09:29 AM
  7. Reference worksheet by partial name ?? wildcard
    By Dale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2006, 07:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1