Forum Discussion
Solved
IF logic between columns - filtering
Hi, I will do my best to describe the issue I've encountered during my current project. There are two tables - Table 1 and Table 2. Both contain various columns and are linked through a referenc...
Could try making a measure:
Display = if([tableoneopenfield]="Closed"&&[tabletwoopenfield]="Closed","Don't Display","Display")
which will then look at each combination and output Display except in the event where both of your columns say closed. You could then look to filter on that?
Could try making a measure:
Display = if([tableoneopenfield]="Closed"&&[tabletwoopenfield]="Closed","Don't Display","Display")
which will then look at each combination and output Display except in the event where both of your columns say closed. You could then look to filter on that?