Forum Discussion

JuanOchoa's avatar
JuanOchoa
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • JuanOchoa's avatar
    JuanOchoa
    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.

parry2k's avatar
parry2k
Super User
4 years ago

JuanOchoa what does this variable return, can you put it in the return?

 

VAR MaxDate =
      CALCULATE (
          MIN ( MAX ( Opportunities[Created Date] ), TODAY () ),      // To avoid errors in case there are created dates after today
         USERELATIONSHIP('Calendar'[Date], Opportunities[Created Date])
      )

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

 

  • JuanOchoa's avatar
    JuanOchoa
    Frequent Visitor
    4 years ago

    With the page filters that I have, it returns 2018/04/30