Forum Discussion
JuanOchoa
4 years agoFrequent Visitor
Active and Inactive relationships creating issues when filtering tables.
I am getting strange results when using two tables connected with an active and an inactive connection. Table 1: Calendar Date Table 2: Opportunities with three relevant columns "Opportunities[C...
- 4 years ago
Solved (Sort of)
I surrounded the whole thing with a
Calculate(
...
...,
USERELATIONSHIP (Calendar[Date], Opportunities[Created Date])
)
It now works, but I think this is ugly and I'd love to understand which part of the original measure was failing.
JuanOchoa
4 years agoFrequent Visitor
Solved (Sort of)
I surrounded the whole thing with a
Calculate(
...
...,
USERELATIONSHIP (Calendar[Date], Opportunities[Created Date])
)
It now works, but I think this is ugly and I'd love to understand which part of the original measure was failing.