Filter table based on multiple OR statement across multiple columns

[rhl94]

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")

)

[v-diye-msft · Accepted solution]

Hi @rhl94 

I believe you can refer to this post:

https://community.powerbi.com/t5/Desktop/FILTER-on-multiple-tables/m-p/304137 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-with-filter-on-multiple-tables/m-p/... 

[amitchandak]

Try like

CALCULATETABLE(
TableA;filter(TableA;
TableA[Invoice] <> -1 ||
TableA[Status] = "Active" ||
TableB[Type] = "Public")
)

[rhl94]

Can't mix table a and b in a filter function