Forum Discussion
Anonymous
7 years agoNot applicable
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
- parry2k
Super User
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.
- AnonymousNot 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")