Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Composite model with USERELATIONSHIP() in calculation group

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?

No Replies