Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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))
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |