Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
6 years ago

Contains

Hello everyone,   I need some help here: Two tables one virtual the other phisical. The virtual returns 18 names and the phisical 35 names I would lke to return A table with all 35 names and true o...
Need Help
Fcoatis's avatar
Fcoatis
Post Patron
6 years ago

Thank you ibarrau ,

 

But I cant create relationships. My data model is more complex than the sample. The problem I cant reference a variable inside

VAR currArbitro = SELECTEDVALUE(Table1[Arbitro])


IF( 'Phisical'[name] IN VALUES ( currArbitro ), "True", "False" ) 

Thats why I´d apprecite if could take a look in the file

 

Thank you so much for your time 

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    I think you are missing something. Maybe a requirement for us or a dax basic. You shouldn't use that currArbitro like you are trying to resolve in a measure. I think that's not going to work.

     

    I have just updated my github with your file. Please check it. I have added a column in all tables asking for arbitro in the others and a visualization about what I think you are trying to accomplish.

     

    Hope this helps because I'm getting confuse on the requirement haha.

    • Fcoatis's avatar
      Fcoatis
      Post Patron
      6 years ago

      ibarrau Thank you!

       

      I appreciate your time and effort to help me. here is the real scenario if you are still interested.

       

      Once again thanks

      • ibarrau's avatar
        ibarrau
        Super User
        6 years ago

        Hey, did you actually try to add my solution to your scenario? I don't know what else to do with that pbix that should be different of what I already said.

         

        Is the pbix from my github solving the problem? if not, can you try to explain the problem over the real scenario ?

         

        Regards,