Forum Discussion

Sander_NL's avatar
Sander_NL
Icon for Helper I rankHelper I
6 years ago
Solved

Check if value meets two criteria

Hi,    I've a table with multiple applications. I need to check if the application has "mw1" OR "mw2". I need a new column with a value true if one of the two middleware components exists (app1) or...
Help
  • az38's avatar
    az38
    6 years ago

    Sander_NL 

    replace comma ",' to ";"

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

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

Hi Sander_NL 

try a measure

Measure = 
var _count = calculate(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[app]=SELECTEDVALUE('Table'[app]) && ('Table'[middleware1]<>"" || 'Table'[middleware2]<>"")))

RETURN
if(_count>0,true(),FALSE())

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Sander_NL's avatar
    Sander_NL
    Icon for Helper I rankHelper I
    6 years ago

    Thanks az38 for  your reply. When I try to apply this to my report I get an error:

     

     

     

     

     

     

     

     

     

    This is the "table"

     

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

      Sander_NL 

      replace comma ",' to ";"

       

      do not hesitate to give a kudo to useful posts and mark solutions as solution