Forum Discussion
Solved
Filter table based on multiple OR statement across multiple columns
Hi
I want to calculate a filtered table based on if one of the three conditions are met across multiple columns and table.
This formula express what I want, but TRUE/FALSE statement across multiple columns are not allowed. Any way to bypass this?
CALCULATETABLE(
TableA;
TableA[Invoice] <> -1 ||
TableA[Status] = "Active" ||
TableB[Type] = "Public")
)
3 Replies
Try like
CALCULATETABLE(
TableA;filter(TableA;
TableA[Invoice] <> -1 ||
TableA[Status] = "Active" ||
TableB[Type] = "Public")
)- Can't mix table a and b in a filter function
