Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hi everyone,
I am trying something that seems very simple but, I dont know why, I am not being able to obtain.
I have a list of absentism and the number of days per absentism and I want to summarize per employee and obtain the employee with the highest number of days of absentism.
Data Sample:
| Employee | Days |
| 1000002 | 1 |
| 1000002 | 7 |
| 1000002 | 1 |
| 1000002 | 12 |
| 1000004 | 6 |
| 1000004 | 17 |
| 1000004 | 4 |
| 1000004 | 3 |
| 1000005 | 1 |
| 1000005 | 26 |
| 1000006 | 1 |
| 1000006 | 3 |
| 1000006 | 1 |
| 1000006 | 4 |
| 1000006 | 19 |
| 1000018 | 3 |
| 1000018 | 1 |
| 1000018 | 19 |
| 1000018 | 112 |
| 1000019 | 5 |
| 1000019 | 3 |
| 1000019 | 1 |
| 1000019 | 2 |
| 1000019 | 11 |
| 1000021 | 1 |
| 1000021 | 1 |
| 1000021 | 17 |
| 1000021 | 2 |
If you make a dynamic table, you obtain this:
I would like to obtain the 563 in a card, it is the total amount of days that the employee 1000226 was ill (for example).
It is really easy in a matrix table but I dont know how to show it in a CARD.
Thank you show much for the help!
Solved! Go to Solution.
@Anonymous,
Try these measures:
Sum Days = SUM ( Table1[Days] )
Max Days = MAXX ( VALUES ( Table1[Employee] ), [Sum Days] )
Proud to be a Super User!
@Anonymous,
Try these measures:
Sum Days = SUM ( Table1[Days] )
Max Days = MAXX ( VALUES ( Table1[Employee] ), [Sum Days] )
Proud to be a Super User!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!