Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mb769
Advocate I
Advocate I

Crossfilter data based on dynamic measure

 

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]))
 
which gives me the following chart (NumberOfStaffInGroup on Y-axis, Group on X-axis), next to a table with all staff members:
mb769_0-1674557029049.png

 

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!

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.