Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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]))
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]))
@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?
Hi @Anonymous,
Could you please post some screenshots of the results returned by above two scenarios to show us the difference?
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |