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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
For the staff, I calculate a 'Dynamic Age' measure, i.e. the age shown depends on the Year I am slicing (the date slicer):
DynamicAge =
CALCULATE (DATEDIFF (MIN(Staff[DoB]), MAX(Date[Date]), YEAR ))
This works perfectly.
I also categorise the staff in groups depending on their age. For this I have a measure
NumberOfStaffInGroup =
CALCULATE (DISTINCTCOUNT(Staff[Staff_ID]), FILTER (Staff, [DynamicAge] <= MAX (Group[max]) && [DynamicAge] >= MIN (Group[min]))
Now, I want to use the interactions, so that by clicking one of those bars, my table is sliced and shows only the staff members in the selected group.
Does anyone know a trick? Joining the agegroup table on a dynamicage measure does not seem to be possible.
Thanks!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 30 | |
| 19 | |
| 12 | |
| 11 |