Two page filters combined with AND

[stupido]

Hello,

I wonder if it's possible to set two filter on a page or a table for two different colums that are combined with a logical AND.

example table:

Material	Actual	Margin
ABC	150	0
BCD	0	120
CDE	0	0

I only want to get rid of material CDE, but when I set two filter "Actual is not 0" and "Margin is not 0" all record sets dissappear.

It seem the logical AND is only available within one column. Is there a way to get to the filtered table?

Thanks

[S_JB · Accepted solution]

You can include this measure as a visual level filter without including it as a column.

Navigate to the 'Add a filter to a visual' section in the below link to see how this can be done:

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter 

[S_JB]

You could create a new measure which sums actual and margin, then use this as the filter:

Combined = Table[Actual] + Table[Margin]

[stupido]

Combined = Table[Actual] + Table[Margin]

doesn't work for me, as I can not use a column name without aggregation directly in a measure.

This one will work:

Combined = SUM(Table[Actual]) + SUM(Table[Margin])

but I' have to add it to my table. I donn't want the user to see this column.