Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to apply an OR filter to a visual ?

Hi Guys,

 

I want to create an OR Filter that allows MTDCY_Flag = 1 OR MTDP_Flag = 1;

 

When i click on the drop down there is no OR. It just shows me basic filtering and Top N

 

How do i create the filter to Utilize the OR function for these 2 Flags?

 

Please see screenshot 

 

 

 

 

Thanks 

StarLord.

  • Anonymous you cannot have OR between two differnt columns used, you can create another column with your OR logic from these two columns and then use that for filtering.

2 Replies

  • Anonymous you cannot have OR between two differnt columns used, you can create another column with your OR logic from these two columns and then use that for filtering.

    • Anonymous's avatar
      Anonymous
      Not applicable

      You probably need to write a calculated column that compares the two measures you are running. Something along the lines of:

       

      Column = IF([Measure]="True", OR([Measure 2]="True", "True"), "False")