Forum Discussion

mhilzendegen's avatar
mhilzendegen
Regular Visitor
4 years ago

Relationship not working

Hi there,

so, Power BI is being Power BI again... I have referenced an existing data source (else there is a circular logic) and have related it to the proper other data source. When I want to do a related, that source does not appear. Please help! See screenshots for more info.

 

 

Last screenshot you see that i get the measures from api_pd_activities , but not from the referenced and related api_pd_activities 2. api_pd_activities is related through a different relationship:

 

 

 

I am running out of ideas

 

Thanks
marko

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    mhilzendegen it is not clear from your post what you are trying to do. If you try to add a column on one side of the table using a related function and want to use a column from many sides of the table, it will not work. 

     

    If the above is not trying to do, please explain what is your actual question?

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    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.

    • mhilzendegen's avatar
      mhilzendegen
      Regular Visitor
      4 years ago

      parry2k yes, thanks i just realized that as well.

       

      My use case is the following i have several calls in the activities data source - which are related to deals. I want to grab the lowest and the highest date for each of the calls that happened in a deal.

       

      My normal approach would be  filter( id == id) and grab the data i need, but filter does not work with lastdate because it yields a table and not a column.

      doing addcolumn does not work because that does not work with lastdate.

       

      doing jsut lastdate to the activities works, but there are more than calls in there, so i need to filter by type as well. I would need sth. like this, which I know, does not work 

      #c_DealActive = LASTDATE(FILTER('api_pd_activities (2)', 'api_pd_activities (2)'[Activities - Art] <> "brief"))

       

      Marko