Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago

Filtering based on two calculated columns using OR

I have two calculated columns with results either showing "yes" or "no" based on due dates.  How can I filter to show results that are Yes for column A   OR       Yes for Column B   Column A       ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

jcastr02 , Try a measure like

calculate(countrows(Table), filter(Table, table[Column A] = "Yes" || table[Column B] = "Yes"))

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    5 years ago

    Hello amitchandak   I tried that but all the values are coming up the same.  Looking for it to show "include" if Either column "Accept SLA late?"="yes"    OR "Fix SLA late?"="yes"   if not , Exclude...

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      jcastr02 , I suggested a measure.

      For a column 

      if(table[Column A] = "Yes" || table[Column B] = "Yes" , "Include", "Exclude") // One is yes

       

      or

       

      if(table[Column A] = "Yes" && table[Column B] = "Yes" , "Include", "Exclude") // Both should be yes