The difference between filter function and a filter in CALCULATE function

[ted_kim]

Hi! I always thank the members of the community.

I have a question.

Filter function and CALCULATE(<extension>, <filter1>, <filter2>...)

I wonder what is different.

If you know anyone, please answer me.......

[themistoklis · Accepted solution]

@ted_kim

Filters are enclosed in other functions so as to filter the results which can be measures or dimensions.

Measure =                                                                       
CALCULATE (
    SUM ( Table[value] ),
    FILTER ( Table, Table[City] = [selected city] )
)

As a standalone function it can only be used to create a table with filtered rows

Table_New = FILTER('Table', 'Table'[User_ID] = "Ted")