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 false if none matches (app2).

 

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

3 Replies

  • 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