Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Not very clear
You can use all or remove filters
calculate([Meausre],all(table))
calculate([Meausre],all(table[column))
calculate([Meausre],removefilters(table[column))
Not very clear
You can use all or remove filters
calculate([Meausre],all(table))
calculate([Meausre],all(table[column))
calculate([Meausre],removefilters(table[column))