Composite model with USERELATIONSHIP() in calculation group

Anonymous — Fri, 31 Mar 2023 07:55:56 GMT

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?

topic Composite model with USERELATIONSHIP() in calculation group in DAX Commands and Tips

Composite model with USERELATIONSHIP() in calculation group