Escape visual filter

[Anonymous]

Hi, wonder is this is possible. I have a matrix visual which is displaying list of people (managers only). The filter on this visual is set 'user AD'[IsManager] = 1

Now I want to put a value to the matrix for team stats:

Active Meeting Participants =

VAR Yes_Count =

    CALCULATE (

        DISTINCTCOUNT ( 'Teams statistics'[User Principal Name] ),

        'Teams statistics'[Active Meetings Participant] = "Yes",

        'user AD'[IsManager] = 0

    )

RETURN

    IF(Yes_Count>0, divide(Yes_Count,[Team Count]),0)

Is it possible to avoid visual filter in this case ? As for the moment it shows me incorrect stats since it adds up manager’s statistics. And I want only teams statistics to be displayed next to the team manager.

[amitchandak · Accepted solution]

@aleksandra_stan ,

Not very clear

You can use all or remove filters

calculate([Meausre],all(table))

calculate([Meausre],all(table[column))

calculate([Meausre],removefilters(table[column))