Userelationship in a measure with other Filters applied yields wrong results

[Anonymous]

Hello everyone, I have one fact table and one master calendar. The master calendar has an active relationship on open_date and one inactive calendar on close_date (this is a ticketing system)

 

And I also have one measure:
Measure1 = CALCULATE(SUM(FactTable[hrc_u_volume]),FILTER(FactTable,FactTable[^states_groups]="Resolved"),USERELATIONSHIP(Mastercalendar[DateText],FactTable[closed_at_text]))

Measure2 = CALCULATE(SUM(FactTable[hrc_u_volume]),USERELATIONSHIP(Mastercalendar[DateText],FactTable[closed_at_text]))

And the weird thing is, if I put Measure 2 in some graph and put as visual filter : ^states_groups]="Resolved"

I yield the right result

If i use directly Measure2 I have less results (wrong result), because somehow it counts the ^states_groups]="Resolved" but also filters using the active relationship.

So instead of just using the Resolved filter and the inactive (turned active) relationship... somehow it also uses the default Active Relationship (which should not).

Why when I use that extra Filter on Measure1 it "activates" the relationship I am trying to avoid?

Best Regards!

[Anonymous · Accepted solution]

Measure one has to be written like this to yield correct results, dont really know why though:

Measure1 = CALCULATE(SUM(FactTable[hrc_u_volume]),FactTable[^states_groups]="Resolved",USERELATIONSHIP(Mastercalendar[DateText],FactTable[closed_at_text]))

[Michieldo]

@Anonymous thanks for your answer, I faced the same problem.

I do wonder why this is the case though. If we use "USERELATIONSHIP", we shouldn't use the "FILTER" function if we want to filter over the same table as the table used in the expression?

[v-yulgu-msft]

Hi @Anonymous,

Could you please post some screenshots of the results returned by above two scenarios to show us the difference?

Regards,

Yuliana Gu