Filter on multiple columns

[zoomerin]

When using CALCULATE, is implicit filter enough or explicit filter is required for multiple columns filtering?

I read in a book that explicit filter is required for multiple column filtering, but implicit filter also working in my example. 

Please clarify if there has been any recent update on this. 

Thank you. 

 

[v-kongfanf-msft · Accepted solution]

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.