Hi!
I have a composite model with one DQ table and three aggs, only two are relevant for this question.
I have a slicer that filters for unit category with a switch, and this works fine with the aggs. I recently added another slicer that switches relations with the date-dimension, this is defined in a calculation group with two items:
Opprettet dato =
CALCULATE( SELECTEDMEASURE(), USERELATIONSHIP(fakkundeordre[OpprettetDato], dimkalender[Dato]) )
Ønsket leveringsdato =
CALCULATE( SELECTEDMEASURE(), USERELATIONSHIP(fakkundeordre[ForespurtLeveringDato], dimkalender[Dato]) )
Now the queries dont hit the aggs, and I can't really understand why. The new date fields are included in the aggs, I have tripple checked the configurations in "manage aggregations". I suspect the USERELATIONSHIP() might be the culprit, but I dont know.
Does anyone have experience with this?
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
