Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi @Baks007
please try
Met =
SUMX ( VALUES ( 'Date'[MonthYear] ), INT ( [Attendence %] >= 0.95 ) )
Not Met =
SUMX ( VALUES ( 'Date'[MonthYear] ), INT ( [Attendence %] < 0.95 ) )
Hi @Baks007
please try
Met =
SUMX ( VALUES ( 'Date'[MonthYear] ), INT ( [Attendence %] >= 0.95 ) )
Not Met =
SUMX ( VALUES ( 'Date'[MonthYear] ), INT ( [Attendence %] < 0.95 ) )
User | Count |
---|---|
53 | |
22 | |
18 | |
18 | |
13 |
User | Count |
---|---|
89 | |
87 | |
50 | |
34 | |
22 |