Forum Discussion
Anonymous
3 years agoNot applicable
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