Filter on multiple columns

Hi zoomerin ,

The first thing you can do is to see from which external display filters the current visual object is subject to according to the funnel in the upper right corner.
Also in calculate, if an implicit filter condition in the formula conflicts with an external filter condition, then the internal filter will override the external filter condition.
For example, in table visual, although it is subject to filters from the date and cate tables, the internal filter of the calculate formula created overrides the filter from the cate table.

result_ =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER ( ALL ( Cate[Category] ), Cate[Category] IN { "a", "b", "c" } )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.