Forum Discussion

justivan's avatar
justivan
Helper II
5 years ago
Solved

Userelationship inside Summarize

Hi All, Is it possible to activate the relationship inside a summarize? I need to do a currency conversion for both purchase and sales so I need them both in a relationship but can't activate them b...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi justivan ,

     

    According to your description, for choosing USERELATIONSHIP or LOOKUPVALUE, in some cases, for USERELATIONSHIP, In fact, the context transition still operates using the original relationship and its effect needs to be removed. The advice is to never write such code, It is better to rely on a simpler version (LOOKUPVALUE), which does not use relations at all.

     

    You can also read the following blog and similar case to deepen your understanding:

    Expanded tables in DAX - SQLBI

    Solved: Re: using inactive relationship - Microsoft Power BI Community


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

justivan , In the addcolumns, when adding a new one, You should be able to use userelationship inside the calculate

  • justivan's avatar
    justivan
    Helper II
    5 years ago

    Hi amitchandak ,

    Thanks for the feedback.

    Yes I can use USERELATIONSHIP inside the CALCULATE but the problem is in the SUMMARIZE because there is no active relationship between the 'Bookings' table and 'Conversion_Rate' table.