Additional wildcard Filter for LOOKUPVALUE

[Anonymous]

Hello & Happy Friday,

Using the DAX LOOKUPVALUE code below is it possible add an additonal wildcard filter on CRITSITS'[CritSit Event Type] = "*Metric*"?

The DAX code below works great but I need an additional wildcard filter to narrow down / pin point the desired results.

Thank you in advance

CritSitVerified = 
    IF(ISBLANK(
        LOOKUPVALUE('CRITSITS'[CritSit Event Type],'CRITSITS'[Ticket ID], 'CROutages'[RTPA])),"No","Yes"
)

[candresbq]

Hello everyone.

I would like to know how you can use the lookupvalue function with a filter, if you have any example it would be very helpful.

Thank you.

[Greg_Deckler · Accepted solution]

You may have better luck with just simple filtering like this:

CritSitVerified = 
    IF(ISBLANK(
      MAXX(
        FILTER(
          'CRITSITS',
          'CRITSITS'[Ticket ID] = 'CROutages'[RTPA] &&
            (SEARCH("Metric",'CRITSITS'[CritSit Event Type],1,-1) > 0)
        ),
        'CRITSITS'[CritSit Event Type]
      )),
"No","Yes")

[Anonymous]

Hello Greg,

You are truly amazing, your solution worked and fix my problem instantly.

Many thanks & have a great weekend 😉

Don

[az38]

Hi @Anonymous 

try a column

CritSitVerified = 
var _lookUp = CALCULATE(FIRSTNONBLANK('CRITSITS'[CritSit Event Type], 1), 'CRITSITS'[Ticket ID] = 'CROutages'[RTPA], SEARCH("Metric", CRITSITS'[CritSit Event Type] )> 0 )
RETURN
    IF(ISBLANK(_lookUp),"No","Yes")