Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Additional wildcard Filter for LOOKUPVALUE

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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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")

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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")